Steps to Add Control Flow

To add control flows to the package you've been building, follow these steps:

• If the Toolbox isn't visible already, hover your mouse over the Toolbox tab until it slides out from the side of the BIDS window. Use the pushpin button in the Toolbox title bar to keep the Toolbox visible.
• Make sure the Control Flow tab is selected in the Package Designer.
• Drag a File System Task from the Toolbox and drop it on the Package Designer.
• Drag a Data Flow Task from the Toolbox and drop it on the Package Designer, somewhere below the File System task.
• Click on the File System Task on the Package Designer to select it.
• Drag the green arrow from the bottom of the File System Task and drop it on top of the Data Flow Task. This tells SSIS the order of tasks when the File System Task succeeds.
• Double-click the connection between the two tasks to open the Precedence Constraint Editor.
• Change the Value from Success to Completion, because you want the Data Flow Task to execute whether the File System Task succeeds or not.
• Click OK.
• Select the File System task in the designer. Use the Properties Window to set properties of the File System Task. Set the Source property to DepartmentList. Set the Destination property to DepartmentListBackup. Set the OverwriteDestinationFile property to True then click OK.

   As it stands, this package uses the file system task to copy the file specified by the DepartmentList connection to the file specified by the DepartmentListBackup connection, overwriting any target file that already exists. It then executes the data flow task. In the next section, you'll see how to configure the data flow task.