In this example, we will start working with the Control Flow task, use File System Task to move a file, and also use Execute SQL Task to interact with a database and write a log entry. We will also work with Precedence Constraint to define the priority and order of execution of items in the Control Flow window. Perform the following steps to explore the options in the Control Flow window:
Create a package-level variable in the Variables pane, name it
FilePath
with a string data type, and set its path to theCustomers_1.csv
file.Drag-and-drop a File System Task from the SSIS toolbox into the Control Flow tab.
Double-click on the File System Task in the Package Designer; the File System Task Editor will be opened.
Set the Operation option as Move File, set IsSourcePathVariable to true, and choose User::FilePath as SourceVariable:
Keep IsDestinationPathVariable as False and create a destination connection to an archive folder (a folder that we use...