Friday, March 9, 2012

DTS package acting weird

I have built a DTS package in SQL Server 2000 to Delete all rows from a table and then import from another table. I have scheduled it run twice a day and everytime it runs, it does not delete anything but imports all the records from another table. So when its done, I have twice the number of records in my final table. Then I go back to the server and execute the package manually and it works perfect. It deletes all and then imports new. I have enabled package logging and it shows both the steps executed perfectly (even when it executes on scheduled time).

What can be the problem?

Thanks,

Bullpit

I think I found the problem. I had two packages which did the same job and at the same time. That probably was the reason I had twice the actual number of records.Embarrassed

No comments:

Post a Comment