Transformation Options (Phases Tab)
Use this tab to select the transformation phase or phases you will implement by supplying and registering a COM object. You do not need to use this tab if you are supplying Microsoft® ActiveX® script functions to implement multiphase data pump functionality.
Options
Pre source data function
Call a function before the first fetch of source data. You create functions for the pre source transformation phase primarily for writing header rows to the destination.
Row transform function
Call the default transformation function for copying and transforming data. Creating a function only for this transformation phase is the same as not using the multiphase data pump feature.
Post Row Transform Function
Specify that post row transformation functions are executed after the row transform phase of the data pump. Only one of the following post row transform functions can be called for a row: On insert success, On insert failure, and On transform failure.
On insert success
Create a function to be called on success of an Insert operation (or Insert query if the transformation is part of a Data Driven Query task). You cannot specify any destination operations in the returned status.
On insert failure
Create a function to be called on failure of an Insert operation (or Insert query if the transformation is part of a Data Driven Query task). You cannot specify any destination operations in the returned status.
On transform failure
Create a function to be called on failure of the normal transform phase (when the row transformation returns DTSTransformStat_Error or DTSTransformStat_ExceptionRow). Writing a function for this transform phase allows you to handle transformation errors (for example, type mismatches), overriding the value returned by the transformation and continuing with execution.
On batch complete
Create a function to be called on success or failure of a batch or rows, as defined by the value specified in Insert batch size in the Options tab of the Transform Data task. Setting a batch size for a Data Driven Query task or parallel data pump task can only be done programmatically. Therefore, if you want to write an On batch complete function for either of those tasks, you should do so programmatically as well.
On pump complete
Create a function to be called at the end of the transformation task (after all rows have been processed). Use functions written to On pump complete to free up resources and commit data held in global variables throughout the lifetime of data pump. You cannot access the data through an On pump complete function.
Post source data function
Create a function for processing the destination data after completion of the task. Unlike On pump complete functions, functions written to this phase allow you to access the destination data. Common uses of a post source data function include writing footer rows to a file, freeing up resources, and committing data held in global variables.
See Also
Multiphase Data Pump Functionality