SSIS
Last updated
Was this helpful?
Last updated
Was this helpful?
We'll begin with the basics and then build up from there!
A simple outline of using the import and export wizard to copy data from a SQL table, exporting it to a destination file (text file or excel file)
SQL Server Data Tools has various Integrations Services Tools that enable you to create sophisticated ETL Solutions. In this example we’ll be export data from SQL to a “.Txt File”
The Execute Package Utility provides an easy to use user interface for executing packages, as well as for changing settings prior to running a package.
Data Flow sources provide connectivity to various data sources i.e. databases or Flat Files. A Data Flow object in SSIS reads data from a source and outputs data in columns to the Data Flow Pipeline.
Data Flow Destination provide a way for various data sources i.e. databases or Flat Files to connect to the Data Flow Pipeline. A Data Flow Destination object reads data from the Pipeline and the passes the data to the destination.
