Hands-On Microsoft SQL Server 2008 Integration Services part 19. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 158 Hands-On Microsoft SQL Server 2008 Integration Services Figure 5-6 Configuring the Foreach Loop Container to enumerate fully qualified filenames Exercise Configure File System Task In this final part you will configure the File System task to move the downloaded zipped files from the C SSIS downloads folder to the C SSIS downloads Archive folder. This task will move the files one by one with each iteration of the Foreach Loop Container. It will use the variable User fname populated by Foreach Loop Container to determine the source filename. 8. Drag and drop the File System task from the Toolbox within the Enumerating Files Container. 9. Double-click the File System Task icon to open the File System Task Editor. Select Move File in the Operation field. In the General area on the right pane fill in the following details Chapter 5 Integration Services Control Flow Tasks 159 Name Archive downloaded files Description This task copies downloaded files from the downloads folder to the Archive folder. 10. In the Source Connection section set IsSourcePathVariable to True. 11. Click in the SourceVariable field and then click the down arrow to see the dropdown list. Choose User fname as shown in Figure 5-7. 12. In the Destination Connection section verify that IsDestinationPathVariable is set to False. Figure 5-7 Configuring the File System task for moving files 160 Hands-On Microsoft SQL Server 2008 Integration Services 13. Click in the DestinationConnection field and then click the down arrow to see the drop-down list. Choose the New Connection. to open File Connection Manager Editor. In the Usage type field select Existing Folder and type C SSlS downloads Archive in the Folder field. Note that a File Connection Manager named Archive has been created. 14. The OverwriteDestination field allows you to overwrite the files with the same name at destination folder. Be mindful while configuring this option in the production environment. Leave it set at the default value of .
