DTS package fails when scheduled after beginning to load data

[kodaksmile]

I have a strange issue with a DTS package. First we are running sql 2000 sp3. We have a DTS package that truncates a table and then loads data from a text file to the table. When I try to run the job it truncates the table, loads 5000 rows (out of 240000+ rows) and fails with the following message:

Executed as user: xxxx\SvcSQLAgent. ...tep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Copy Data from file to [our_DB].[dbo].[table1] Step DTSRun OnProgress: Copy Data from file to [our_DB].[dbo].[table1] Step; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: Copy Data from file to [our_DB].[dbo].[table1] Step; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: Copy Data from file to [our_DB].[dbo].[table1] Step; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: Copy Data from file to [our_DB].[dbo].[table1] Step; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: Copy Data from file to [our_DB].[dbo].[table1] Step; 5000 Rows hav... Process Exit Code 1. The step failed.

It fails in 15 seconds. When I run the DTS package manually it runs fine (completes in a couple minutes)

Any suggestions? I haven't found any additional errors in any of the logs.

 

[AlexCuse]

Are you logging errors? That information would be tremendously helpful.

Does it always fail in 15 seconds? If so I wonder if it is some kind of timeout issue. You might try running the job to load only the first 5000 rows, and then the first 10000, and see if it fails on each of those.

First I'd set up your package to log errors though. Until we know what the error is, everything is going to just be a guess.

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page