Post reply

DTS Job Fail "Rows have been transformed or copied"

  • July 3, 2007 at 1:19 am

    #62910

    Hi everyone,

    I have some problem with a DTS failed, i have read a lot of Topics about this kind of error,  otherwise i don't find what could be the answer which could have been helping me...

    We use SQL Server 2000 and i have a failed job with this error :

     OnStart: 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; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000 ... Process Exit Code 1. The step failed.

    I know that the better way to debug a step failed is to enable the log file, but i am a newbie and i replace a guy recently gone away, so i didn't known this DTS before today... I have enable the log file and restart the job however he didn't fail so i would like to know if someone of you could know from where the error could come from?

    Thanks

  • July 3, 2007 at 2:16 am

    #716787

    Are you running this DTS as a job then place a log file in the job and track on which step the DTS fails so that you can rectify them with ease.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 3, 2007 at 2:46 am

    #716795

    I, no this DTS is running as a step of a job, there are others steps after and before, but it stop at this step. The log file is put on the package of this DTS in the error handling (DTS Package Properties).

    In fact the problem is that now the step of this DTS doesn't failed, so I would like to know if someone could know where could it come from.

    For the next failed step i will have the log file...

  • July 3, 2007 at 8:21 am

    #716890

    It looks like the package failed on DTSStep_DTSDataPumpTask_1, but there is really no way to know what caused it to fail until it happens again and you can examine the package log.

    Greg 

    Greg

  • July 3, 2007 at 9:05 am

    #716912

    Hi,

    Ok, you are right, anyway thanks for the answer, next time (i hope not) i will give you the content of the package log

    Bye.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply