January 10, 2005 at 9:42 pm
Hi,
we have a dts job which was working fine before but suddenly from last couple of days it started failing. I donot have any info regarding what is there in that dts package. All i can get info regarding the dts package is that it hold an OS related command. I am not sure if i can add an output file to this package (rights??). can anybody guess whats happening???
any help would be really appreciated
Executed as user: SQLADMIN. ...SRun 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.
January 11, 2005 at 4:59 am
I usually get this type of error when theres a problem with the source. I would suggest that whoever has rights to amend the package enable package logging. This will give you much more information to help track down the problem.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply