SSIS
Getting Started with SSIS
We'll begin with the basics and then build up from there!
Import/Export Wizard
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)
Build Package with SQL Server Data Tools
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”
Run Package with Package Utility
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.
Create DataFlow Source
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.
Create DataFlow Destination
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.
Last updated
Was this helpful?