Number of transfers in a DTS package

[LonnieJohnson]

How many transfers can you put in a DTS package to ensure safe execution?

I have a process that copies data from about 25 SQL tables into Access tables each day. The purpose of this is to have the data in a shared drive as a back up. Each time a use logs on this is copied to their hard drives by a batch job. Then if the system goes down they can view data via an emergency front end that is linked to the access tables on their hard drive.

My problem is that some of the table won't copy over. I get a message saying...


The number of failing rows exceeds the maximum specified.
Could not update; currently locked by user on machine 'kvc-ks'


It never happens on the same table twice. I have nothing open on this computer so nothing can be locking it. Sometimes it runs ok. Do I have too many jobs trying to run at once?

My DTS package deletes the data then copies (appends) new data. The append for each table is dependent upon the success of the delete.

Help.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[JayKusch]

It seems you are having data issues w/ your import ...
The number of failing rows exceeds the maximum specified.


I would suggest turning on the logging of your package to capture more verbous info to a text file for further review. Please post what the error log relays.



Thanks

J. Kusch

 

[LonnieJohnson]

Thank you J for responding.

How do I turn on the log writing process?

I'd also like to note that I can run this process and it will fail for a particular table, then run it again imediately and it will fail for another table and no data has even changed. I didn't know if this would affect your thoughts about it being the data.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!