MS SQL Server DTS - how to define flow (Precedence) in DTS

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

how to define flow (Precedence) in DTS

Ghulam Farid

2006-03-25, 7:42 am

Hi

I have created a DTS in which first i m deleting values then populating
data from text file. the problem is that i have to open the pakage and
then execute each process manually in the pakage.
wht i want to know how can i confiqure the flow that i only execute main
package then, first data is deleted from tables and then data is
populated in tables.
How can i define it. i have one Execute SQL Task object
and two data transformation tasks (text to SQL Server).

Regards

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links