Hi,

Why not create a package of DTS packages and run it using "Execute Package
Task" in Design Package? You should be able to control the order in which
100 packages can be run if needed as well as which version of each package
to run. Once you create the package of packages.... you can schedule it to
run at the desired time.

I know this works in SQL Server 2000. I am not sure of other versions.

Hope this helps.

Sang Nahm

-----Original Message-----
From: Farnsworth, Dave [mailto:[Email Address Removed] Wednesday, October 30, 2002 7:04 AM
To: LazyDBA.com Discussion
Subject: RE: DTS ?


Schedule them as jobs and have them start at the same time. That may be a
load on your system though, depending on what the DTS's are doing.

Dave

-----Original Message-----
From: Usman Farhat [mailto:Usman.[Email Address Removed] Wednesday, October 30, 2002 3:56 AM
To: LazyDBA.com Discussion
Subject: DTS ?



Hi Guys !
I got some 100 packeges Of DTS ... I wana Execute them once at
particular time togather , what is exact method for executing them togather
, because now i am executing them manually ... I wana execute them once and
togather ... Please Help ... Thanks In Advance ... Usman FArhat

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page