Please see my other Business Intelligence articles.
SSIS is Microsoft’s ETL platform which was designed to migrate and manipulate data in support of the Business Intelligence (BI) lifecycle (SQL Server, SSIS, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS). For more information, please read SSIS: An Overview.
| SQL Server Integration Services (SSIS) | |
|---|---|
| An Overview An Overview of SQL Server Integration Services (SSIS). |
Commenting Commenting (annotating) your SSIS Package. |
| An Overview of Control Flow A brief introduction of Control Flow. |
An Overview of Data Flow Transporting data from a source to destination. SSIS: An Overview of Variables Enabling data-sharing between tasks within a package. |
| Audit Transformation Adding additional data to the output related to package execution. |
Conditional Split Transformation Integrating conditional logic into the data pipeline. |
| Create Folder Using a file-system task to create a folder. |
DataFlow The primary component for extracting, transforming, and loading data. |
| Dataview Debugging with a DataView. |
Derived Column Transformation Transformation data into new fields. |
| DTExecUI Executing SSIS Packages with a stand-alone application. |
Excel Destination Creating a new Excel spreadsheet at runtime and writing data into it. |
| Execute SQL Task Integrating Custom SQL Into the Package. |
File Iteration Using custom C# code to iterative through files. |
| File Monitoring Using a For Loop and Script Task objects to monitor the filesystem. |
ForEach Loop Container Performing complex, iterative actions. |
| Multicast Transformation Implementing conditional logic to redirect output. |
Nested tasks Combining tasks to perform complex, iterative actions. |
| Package Import/Export Wizard Executing the Import/Export Wizard within a package. |
Package Level variables Sharing custom variables between tasks in a package. |
| Precedence Constraints Controlling the execution sequence of tasks. |
Sort Transformation Controlling the sort order of data within the pipeline. |
| SQL Server to Datareader Exporting from SQL Server to a DataReader. |
Table to Text file Creating an SSIS Package to consume a table and write the recordset into a textfile. |
| Text file sources Reading data from text files. |
Union All Transformation Combining records from different data sources. |
| Using Views Using Views to generate source data within a package. |
An Overview of Variables Enabling data-sharing between tasks within a package. |
TechMbaBi 