Today, we will summarize all SSIS articles into one article and make a simple directory for easy searching.
SSIS is an intelligent solution of Microsoft, popular and ASP. net program, it also designed a lot of similar controls, but called tasks, the main function of these tasks is to convert data from the data source to the data purpose, there will be a query in the middle, aggregation and other more specific tasks. As long as you are familiar with SQL scripts, you will not be confused about these things. This series of articles is to read books, verify the actual operation, and then assign them the text, there is no technical content, you are welcome to exchange and learn.
Common SSIS package-common attributes
Common SSIS package-execute tasks
Common SSIS packages-Bulk
Insert task)
Common SSIS packages-use Bulk
Insert execution task
Common SSIS package-Data Flow task
Common SSIS packages-File System Tasks
Common SSIS package-FTP task
Common SSIS package-execute a package task
Common SSIS packages-scripts and component tasks
Common SSIS package-send email tasks
Common SSIS package-Message Queue task
Common SSIS package-web service tasks
Common SSIS package-WMI data reading task and WMI event Listening Task
Containers and data streams in SSIs-Brief Introduction
Containers and data streams in SSIs-Data sources
Containers and data streams in SSIs-data objective
Transformations)
Transformations
Containers and data streams in SSIs-Example of data conversion tasks
Containers and data streams in SSIs-data view of debugging tools
Create an SSIS package-create an end-to-end package
Create an SSIS package-typical ETL data cleansing
Create SSIS package-loop and Dynamic Package
SSIS advanced conversion task-Execute SQL statements
SSIS advanced conversion task-import Column
SSIS advanced conversion task-export Column
Address: http://www.cnblogs.com/tylerdonet/archive/2011/01/03/1924990.html