Hands-On Microsoft SQL Server 2008 Integration Services part 21. 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. . | 178 Hands-On Microsoft SQL Server 2008 Integration Services You may want to test the connection by clicking Test once you get the Test connection succeeded message click OK twice to return to the Message Queue Task Editor. 13. Leave the Send Message option selected in the Message field. The settings in General page should be like the ones shown in Figure 5-11. 14. Go to the Send page. Leave UseEncryption set to False. This field can be used to encrypt your messages using an encryption algorithm RC2 or RC4 specified in the EncryptionAlgorithm field. Figure 5-11 Message Queue task configured to send messages Chapter 5 Integration Services Control Flow Tasks 179 15. Select Variable message in the MessageType field as you will be sending a variable value in the message. Select User txtfname in the VariableMessage field. Click OK to close the editor window. 16. Save the package by pressing ctrl-shift-s. 17. Using Windows Explorer move the and files from the C SSIS downloads Archive folder to the C SSIS downloads folder that have been moved to the Archive folder in earlier exercise. 18. Switch to BIDS and press f5 on the keyboard to start debugging. When the package runs notice that the tasks change color from yellow to green twice indicating that the package has moved two files and sent out two messages. When all the tasks turn green stop debugging from the Debug menu or by pressing shift-f5. Close the project by choosing File Close Project. 19. Switch to the Server Manager and notice two messages in the Queue messages folder under SSISprivQ. You might have to refresh the folder if the window was already open. Exercise Build Importing Expanded Files Package In this part of the exercise you will build a new package which will pick up variable messages sent by the Archiving Downloaded Files package earlier from the SSISprivQ messaging queue. 20. In the Solution Explorer add a new package and rename it Importing expanded . 21.
