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

Chapter 10

Manipulating Files with the File System Task

When you need to move, delete, or rename a file, or make just about any other changes to it, the File System Task is the task to use. The File System Task enables you to make changes to files or directories and move them around without having to write custom scripts. The File System Task is a commonly used and powerful task in SSIS. A File System Task can:

• Copy a directory
• Copy a file
• Create a directory
• Delete a directory
• Delete the contents of a directory
• Delete a file
• Move a directory
• Move a file
• Rename a file
• Change the attributes of a file

Figure 10-1

You can bring up the File System Task Editor by double-clicking the File System Task or by right-clicking and selecting Edit. In the editor, you see several fields that you can set to perform the needed operation. The Operation property is the action the task performs when executing. In Figure 10-1 you can see the drop-down menu for the Operation property. What you select in this menu determines which properties will be available to you. For example, when you select Delete file, you do not need a destination, just a source file to delete, so a destination will not be available.

The property IsSourcePathVariable enables you to use a variable for the source. This variable will be a string variable that holds the location of the file, for example, C:\SSIS\FlatFile.csv. ...