How to get transformation result in DTS
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, :) Can i use activexscript in transform data task to determine whether the transformation of current table field failed or succeed? This is because i need to insert the failed field to another table. I don't want to validate the dtssource to do this because the transformation still can be failed. This is the program logic : Function Main DTSDestination("Destination") = DTSSource("Source") Main = DTSTransformStat_OK (Validate current transformation here) IF (TRANSFORMATION FAILED) THEN (INSERT FAILED FIELD VALUE TO A TABLE) END IF END FUNCTION Can i do this in the script? Or i need to use other task like data driven task, activex task, etc. Thanks for the help.