Microsoft SQL Server integration service Summary

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