TAILIEUCHUNG - Microsoft SQL Server 2005 Developer’s Guide- P44

Microsoft SQL Server 2005 Developer’s Guide- P44:SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. | Chapter 10 SQL Server Integration Services 409 Get the columns from the source Dim InColumns As IDTSVirtualInputColumnCollection90 _ 0 .GetVirtualInput _ .VirtualInputColumnCollection Dim col As Dim name As For cols As Integer 0 To - 1 Step 1 col Set the last column delimiter to CRLF If cols - 1 Then vbCrLf Else End If Delimited InColumns cols .DataType InColumns cols .Precision InColumns cols .Scale name TryCast col InColumns cols .Name Next Nothing Dim wrapper As CManagedComponentWrapper _ Dim vInput As IDTSVirtualInput90 _ 0 .GetVirtualInput For Each vColumn As IDTSVirtualInputColumn90 In _ DFDestination _ .InputCollection 0 .ID vInput _ Next Match the input and output columns Dim exCol As IDTSExternalMetadataColumn90 For Each InCol As IDTSInputColumn90 In _ 0 .InputColumnCollection exCol 0 _ .ExternalMetadataColumnCollection DFDestination _ .InputCollection 0 .ID Next 410 Microsoft SQL Server 2005 Developer s Guide Here the data flow destination named DFDestination is created. Its ComponentClassID is set to defining it as an OLE flat file in the file system and the Name of the data flow source is set to FlatFileDestination. Next an instance of the DFDestination object name DestInst is created in order to map the input columns to the columns in the destination output file. You create the .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.