In this appendix you find a list of the most commonly used expressions, 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.
|TASKS||WHEN TO USE|
|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. Information can be passed from the parent package to the child package with configurations.|
|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 can be saved directly in the task, in a file, or in a variable. This task is commonly used to call stored procedures.|
|File System Task||Use this task to manipulate files. This task can move, rename, copy, and delete files and directories. You can also ...|