I am running several ActiveX script tasks that are basically inserting legacy data into the new DB structure. Using stored procedures with cursors has taken far too long so i wrote some relatively simple scripts that handle the job very well and very fast. However, I want to be able to write any errors that arise back to the source DB without failing the task.

I don't expect to get through 100,000's of records without an error somewhere and, as the package will be run unsupervised, I'd rather know it completed while reporting the errors that do arise.



From http://www.developmentnow.com/g/103_...server-dts.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

I should have made it clearer - I am running a DTS package in SQL Server 2000. It would be somewhat easier in 2005 SSIS, I know but I don't have it in this environment.

From http://www.developmentnow.com/groups...hreadid=826864

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com