Microsoft SQL Server integration service Summary

Today, all SSISArticleSummary to an article, make a simple directory for easy searching.

SSIS is an intelligent solution of Microsoft, popular point and ASP. NETProgramAlmost, it also designed a lot of similar controls, but it is called a task. The main function of these tasks is to transfer data from the data source to the data destination, and there will be queries 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 package-bulk insert task)

Common SSIS packages-use bulk insert to execute tasks

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

SSIS advanced conversion task-to use a temporary table in a package, you must set the retainsameconnection attribute.

SSIS advanced conversion task-row count

SSIS advanced conversion task-ole db command

SSIS advanced conversion task-keyword extraction

SSIS advanced conversion task-Keyword Search

SSIS advanced conversion task-fuzzy search

SSIS advanced conversion task-slowly changing dimension)

SSIS script-script task Overview

Script-expression in SSIs

Script tasks in SSIs

Script in SSIs-use the assembly in the script task

Script component in SSIs

SSIS reliability and scalability-Overview

SSIS reliability and scalability-transaction

SSIS reliability and scalability-error output