Dear all,

I have one dts which uploads data from text files. Its working fine as dts. I have scheduled it as a job. I have copied the source files to my server also. but as a job its failing.

the error is as follows:

Executed as user: BARCODE\SYSTEM. ...nStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5764 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5764 ... Process Exit Code 1. The step failed.


I have registered the server as 'sa' account and i tried the same, on the server system itself. On the server also, its working fine as a dts, but failing as a job.

I tried to delete the job and rescheduled it again. Now also its failing. No progress same error.

I copied the same dts to other sql server (my local system sql server). In my local server, its working fine as a dts and job also.

what might be the problem?
what is the problem with the server?

Please help me.