June 9, 2006 at 6:35 am
Hi,
I have a DTS who run every day to feed two tables for the daily production at one of my client. The data comes from 2 "Text File Source". Those files are build with an ActiveX Script Task. There is a "Transform Data Task - Copy Column" between the Text File Source and the DB connection. Actually it worked fine for 6 months.
I've made a minor change in the ActiveX Script Task to change a simple information. The Text File Source are still build correctly and everything execute perfectly, except that... SQL Server says the DTS runned fine and all the rows have been inserted in the 2 tables, but the reality is, one of the table have not been fed, no row inserted at all. When I execute the Task manually, it works. When I execute the whole Package, it doesn't.
Anyone have an idea???
June 9, 2006 at 9:53 am
Is there a task in the package that truncates or deletes from the SQL Server tables? Perhaps the workflow was accidently changed so the delete runs after the import step.
Greg
Greg
June 9, 2006 at 12:59 pm
after verifying your tip, that's exactly what happened! a truncate workflow had strangely changed. wonder why, but, for now, it's fixed.
thanks a lot for the tip, it's really appreciated.
Dominic Gagné
Montréal, Qc, Canada
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply