dbTalk Databases Forums  

DTS steps

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS steps in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jaylou
 
Posts: n/a

Default DTS steps - 01-10-2006 , 11:06 AM






Hi All,
I have a DTS package that copies flat files into my SQL 2000 DB. there are
about 30 steps in this package. This job failed this morning, I have logging
turned on and in the log file there is a failed step:

Step 'DTSStep_DTSCreateProcessTask_1' failed

Can anyone tell me of an easy way to figure out which step this actually is?

TIA,
Joe

Reply With Quote
  #2  
Old   
Ryan
 
Posts: n/a

Default Re: DTS steps - 01-10-2006 , 11:36 AM






The step names can be viewed under WorkFlow Properties. Right Click each
step, WorkFlow Properties and you should see the step name

--
HTH. Ryan
"jaylou" <jaylou (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi All,
I have a DTS package that copies flat files into my SQL 2000 DB. there
are
about 30 steps in this package. This job failed this morning, I have
logging
turned on and in the log file there is a failed step:

Step 'DTSStep_DTSCreateProcessTask_1' failed

Can anyone tell me of an easy way to figure out which step this actually
is?

TIA,
Joe



Reply With Quote
  #3  
Old   
vadim.svinkin@gmail.com
 
Posts: n/a

Default Re: DTS steps - 01-10-2006 , 03:52 PM



There is an easier way, that works only if you filled in Description
fields for you Steps/Tasks.
1. go to Disconnected Mode (under Package menu);
2. Click on Steps node to list all steps;
3. click on the step you're looking for
4. read Description in the right pane.

Vadim.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.