DTS step sequence
-
Hello everyone,
somebody wrote to me that I post it in the wrong place, so I will re-post here:
having problem with DTS. I have a package with a lot of connections to retrieve data from different servers. What I need to do is to include SQL task to truncate tables on local server before I collect this data.
How do I include this task to make it run first?
-
When you look at your DTS package in the designer window, you should see arrows between tasks/connections. These arrows show you the order of operations for your package. Add in the appropriate task to truncate your tables and then right-click on the existing first step in your package and select 'Workflow Properties'. Add in your truncate table step as a new source step. You should then see a green arrow between your truncation table step and your original first step. This means that your original DTS steps will begin upon successful completion of your new truncate table step.
-
Thank you for reply, but i don't think it would help. I have centralized Connection Server A and then about 100 others that using this connection. It's not like step after step, all arrows that you mentioned are going into this Server A connection. SHould I just create another DTS to truncate tables and then call this package from there?
-
That sounds like the easiest way. (Anything for an easy life
)-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply