Hands-On Microsoft SQL Server 2008 Integration Services part 13. 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. . | 98 Hands-On Microsoft SQL Server 2008 Integration Services System task and will see that the variable value is used by the task to create the required folder. 10. Delete the newly created folder FSTdirectory form the C SSIS folder and the connection manager from BIDS by simply selecting it and pressing delete. Click Yes on the pop-up dialog box to confirm deletion of the connection manager. 11. Right-click anywhere on the blank surface of the Control Flow Panel and choose Variables from the context menu. This will open the Variables window. Add a variable by clicking the Add Variable button which is the leftmost button on the menu bar in the Variables window. In the Name column type directory and change the Data Type to String. In the Value field type C SSIS FSTdirectory as shown in the Figure 3-8. 12. Double-click the File System task to open the Task Editor. In the IsSourcePathVariable field s drop-down list select True. Note that this converts the SourceConnection field to a SourceVariable field. 13. Click in the SourceVariable field and select the User directory variable from the list of variables. Click OK to close the File System Task Editor as shown in Figure 3-9. 14. Press F5 to execute the package. The File System task turns green and the Output window shows the Success message. 15. Press shift-f5 to stop debugging the package or choose Debug Stop Debugging. Switch to Windows Explorer to see that the folder has been created. 16. In BIDS choose File Save All and leave the project open as you will return to this project later in the chapter. Review You have created a user-defined variable and used its value to populate the SourceVariable field in the File System Task Editor. Because you specified the IsSourcePathVariable as True so when you run this package the File System task knows that it has to read the value of the SourceVariable field from the User directory variable. Though you have defined a static value to the variable this is a good example of how
