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 Source column, check constraint issues

Author  Topic  tswern Starting Member 10 Posts Posted - 2003-03-03 : 01:26:48 Hi all, I'm having a problem retrieving the column which hits an error when I'm doing DTS Transformation. Is there a way for me to retrieve specific the specific DTSSource column that caused the error from any DTS APIs? I'm using check-constraints to do validation. Say for example I have ten fields. Field number 1 hits error, DTS would go to insertFailed() or transformFailed error handler. Izzit possible for DTS to not immediately go to that exception handlers, but instead process to all the subsequent columns? This is important as columns 2 - 10 might have errors too. This is because if that is impossible, would be a problem to capture errors on columns 2-10. Thanks, regards, tswern Save the dugongs!