>Hi,
>
>  Right off the bat, I am brand new to using DTS.
>
>Using Enterprise Manager 8.0
>
>  I have a production db and a test db. I want to refresh several test
>tables for testing. I've written a package that gets each table from
>source and writes to destination, no problem. But I have 7 tables to
>refresh in order, via primary key, so I have 7 "Transform Data Tasks", I
>have to scramble some data columns during the refresh.
>
>  Now that I have these working I want to know how to run them in order,
>without me hitting the "Execute Step" menu option myself.
>
>  Thank you in advance
>  Eric

> You can use workflows to control the order of the tasks. Set
> the workflows so that upon completion of task 1, task 2 will
> execute, upon completion of task 2, task 3 will execute,
> etc. You can take a look at some of the workflow examples at
> the following site - that should give you an idea of how to
> start setting up your package for order of execution of
> tasks:
> http://www.sqldts.com/103.aspx
>
> -Sue
>
> On Thu, 22 Mar 2007 12:23:40 -0700, eric <pos***@cox.net>
> wrote:
>
>
>>Hi,
>>
>> Right off the bat, I am brand new to using DTS.
>>
>>Using Enterprise Manager 8.0
>>
>> I have a production db and a test db. I want to refresh several test
>>tables for testing. I've written a package that gets each table from
>>source and writes to destination, no problem. But I have 7 tables to
>>refresh in order, via primary key, so I have 7 "Transform Data Tasks", I
>>have to scramble some data columns during the refresh.
>>
>> Now that I have these working I want to know how to run them in order,
>>without me hitting the "Execute Step" menu option myself.
>>
>> Thank you in advance
>> Eric
>
>