Hands-On Microsoft SQL Server 2008 Integration Services part 56. 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. . | 528 Hands-On Microsoft SQL Server 2008 Integration Services If Not Then .Write End If .Write columnDelimiter If Not Then .Write End If .Write columnDelimiter If Not Then .Write End If .Write columnDelimiter If Not Then .Write End If .Write columnDelimiter If Not Then .Write End If .WriteLine End With Close the VSTA IDE and the Script Transformation Editor. We will now move on to create a script destination to write into a nonstandard text file. Nonstandard Text File Destination In this part you will write the asynchronous output to a nonstandard text file. Considering that you can now do some of the configurations yourself this section is kept short and quick. 52. Add a File Connection Manager to create a file in the C SSIS RawFiles folder. 53. Add a Script destination component rename it as Script Non Standard Destination and join it with the asynchronous output from the Script Transformation component. 54. Perform the following in the editor Change the language. Select both the input columns. Rename the Input 0 to DstAsyncInput. Add the Connection Manager and name it as SalesSummary. Chapter 11 Programming Integration Services 529 55. In the Code-design mode perform the following Add the namespace in the Imports section. Create two script variables Dim cmSalesSummary As String Private textWriter As StreamWriter Add the following code for the AcquireConnections method Public Overrides Sub AcquireConnections ByVal Transaction As Object Dim connMgr As IDTSConnectionManager100 cmSalesSummary CType Nothing String End Sub 56. Initialize the textWriter in the PreExecute method textWriter New StreamWriter cmSalesSummary False 57. Close the textWriter in the PostExecute Method 58. Last
