Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Appendix A

SSIS Component Crib Notes

In this appendix, you find a list of the most commonly used tasks and transforms in SSIS with a description of when to use them. Reference these tables when you have a package to build in SSIS and you are not sure which SSIS component to use to perform the needed actions.

When to Use Control Flow Tasks

Tasks	When to Use
CDC Control Task	Use this when SQL Server’s Change Data Capture provides the input data. This task manages the date and Log Serial Number (LSN) range used to identify incoming rows. LSNs are just row numbers used to identify rows in the transaction log.
Data Flow Task	Use this task when you need to pass data from a source to a destination. The source and destination can be a flat file, an OLE DB Connection, or any other connections supported in the connection manager.
Execute Package Task	Use this task when you need to call another package from within a package. The package performing the call is the parent package. The called package is the child package. You can pass information from the parent package to the child package with configurations and parameters.
Execute Process Task	Use this task to call an executable. The executable can be a batch file or an application. This task can call applications to perform functions on the files in SSIS, such as compressing a file. This task is commonly used to call third-party programs like compression or FTP tools.
Execute SQL Task	Use this task to perform any T-SQL operation. The SQL ...