Order of Tasks in DTS -- sql server dts

hals_left
2/13/2007 5:44:33 AM

Iv used the DTS wizard to copy data from one table to another on a
different server suing a query
Now I want to delete the data in table on the target server, I have
added an Execute SQL Task but it runs after the copy. I need it to
always ruun before the copy. How do I define the order?

Thanks.

RLoski
2/13/2007 10:28:01 AM

You can link tasks together using workflows. You select the first task in a
set that you want to run. Then you select the second task in the set. Then
click on the Workflows menu and select the type of workflow.

Also check out the following:

http://www.sqldts.com/287.aspx
http://www.sqldts.com/103.aspx
--
Russel Loski, MCSD.Net

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Order of Tasks in DTS