Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS error handling across all tranformations

Author  Topic 

ronstone
Starting Member

32 Posts

Posted - 2005-09-22 : 15:34:27
I'm import a flat file with 30 fixed width columns. If any of the [30] tranformations fail, I want to log the problematic row (to a table), and move on to the next row.

I can modify each transformation to return the DTSTransformStat_SkipRow, but I don't want to add this to *each* activex portion of the transformation...

ronstone
Starting Member

32 Posts

Posted - 2005-09-23 : 15:02:33
bump...
Go to Top of Page
   

- Advertisement -