DTS Help

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 <poster@.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
|||Sue,
Thank you so much for the help.
Eric
Sue Hoegemeier wrote:
> 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 <poster@.cox.net>
> wrote:
>
>