May 27, 2005 at 2:59 am
hello friends!!!!!!!!
I have one que please tell me where i will get this kind of error message in DTS. I want to view flow of DTS package.
Please Help me out!!!!!!!!!!!!
... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 651 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 651 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 2 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_3; 651 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 651 ... Process Exit Code 1. The step failed.
Thanks And Regards
Shashank
Regards,
Papillon
May 27, 2005 at 6:26 am
It's hard to tell from that error message.
What I ususally do is rerun the package by hand (I manually restart each step one by one). But when I rehit the problem, the error message is ususally more informative.
Can you do that and repost the new error message?
May 27, 2005 at 6:46 am
You can also turn on package logging - it will give you a much better idea of what is failing and why. To do so, Open your DTS Package, go into Package Properties (make sure you don't have any of your job step, connections, etc. highlighted first), go to Logging, and fill out the Log Package to SQL Server section.
I do this on my most important DTS packages. Just make sure to go back periodically and clean out the old logs, so they don't build up too much.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply