Microsoft SQL Server 2000 Data Transformation Services- P6: Data Transformation Services in Microsoft SQL Server 2000 is a powerful tool for moving data. It’s easy to use, especially when you’re creating transformation packages with the DTS Wizard. But it’s also a flexible tool that you can customize to gain a high degree of control over the transformation of your data. | DTS Connections and the Data Transformation Tasks 226 Part II Listing Continued .ExceptionFileOptions 1 DTSExcepFile_SingleFile70 .ExceptionFileRowDelimiter CR LF .ExceptionFileTextQualifier .FetchBufferSize 1 .FirstRow 0 .InputGlobalVariableNames .LastRow 0 .MaximumErrorCount 0 .ProgressRowCount 1000 .SourceSQLStatement End With tsk Create step for task Set stp With stp .Name stp sBaseName .Description sBaseName .TaskName End With stp fctCreateDataDrivenQueryTask Set conSource Nothing Set conDest Nothing Set tsk Nothing Set cus Nothing Set stp Nothing ProcExit Exit Function ProcErr MsgBox - GoTo ProcExit End Function Conclusion The Data Driven Query task is a useful tool when you need to specify multiple results for a data transformation. The next chapter explains how to use multiple phases with the transformation tasks. 9 The Multiphase Data Pump IN THIS CHAPTER Enabling the Multiphase Data Pump 228 Programmatic Flow with Multiple Phases 230 Using the Phases 233 Creating a COM Object with Visual C to Program the Phases 243 Creating a Multiphase Data Pump in Code 243 DTS Connections and the Data Transformation Tasks 228 Part II The multiphase data pump option allows you to write code at several different points in the data transformation process. You can use this option with the Transform Data task the Data Driven Query task and the Parallel Data Pump task. If you haven t enabled the multiphase data pump you can write code for only one point of the data transformation process the point at which each row is being transformed. After enabling this option you can write code for all these phases and subphases Pre Source Phase Before the source query is executed. Row Transform Phase Each row of data is processed. On Transform Failure Subphase of the Post Row Transform phase. Occurs when there is an error in the transformation. On Insert Failure Subphase of the Post Row Transform .
