SSIS Learning Notes

The SSIS full name (SQL Server integration Services) is a great tool for Microsoft BI solutions. In addition to being an ETL tool, there are outstanding performance in the following areas:

(1) System maintenance:

1) In Database maintenance: Database backup, statistics update, database Integrity check, index rebuild SSIS package execution, SSAS task processing.

2) Business process: Execute SQL task; Web Service task.

3) Operating system maintenance: WMI Event Watcher task, file System task.

4) Other: Execute SQL task, execute Process task, ActiveX Script task, Script Task (vb/c#), execute WEB Service service.

(2) SSIS architecture consists of four main components: Integration Services, Integration Services object model, Integration Services
Run-time and run-time executables and data flow tasks that encapsulate the data flow engine and data flow components ():

(3)

1. The Data Flow task consists of three different types of data flow components: source, transform, target. The source and target are the data storage, the data flow is the core of ETL, and the transformation is the core of ETL core.

SSIS Learning Notes