Hello,

I am having a problem when I run my DTS. It has multiphase data
transformation where in I get data from diff dw tables and load it
into a staging table. Finally I update the main table from staging
table data. I am using activex script for doing the transformations.
The problem I am facing is that though I am able to catch most of the
errors, I am not able to catch primary key violation error. In the
activexscript phases, if I check dtstransformphase.errorcode, i get
something which is not 0, indicating that the step has failed. But I
am not able to capture the rest of the error description

Can someone help me with this..

Thanks

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/DTS-Unable-c...ict234708.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=813939