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.developersdex.com ***

In the DTS package, you can control the workflow of the package. The
workflow button in the second row left corner will allow you to define
actions depending upon completion, success, or failure. If you
highlight the 2 steps you want to create a workflow for, but you will
want to hightlight them in workflow order, and click the workflow
button and choose success. This will cause the workflow arrow, green
for success, so appear between the 2 objects, pointing from the first
highlighted object to the second. If you were to run the package now,
it would sucessfully complete the first object, then start working on
the second.

You can have mutliple workflows from and to objects. If a object
completes, it can cause 2 or more new objects to start. You can also
have multiple objects complete before a new object starts, by pointing
multiple workflows to 1 object. The one object will not start until all
other workflows have completed as required.

Steve