[dba-SQLServer] Run a DTS package from another DTS Package

Michael Maddison michael at ddisolutions.com.au
Wed Jul 8 19:58:47 CDT 2009


Hi Darryl,

I'm pretty sure you can create a DTS package in 2K and just add a
Execute Package Task object and away you go.
Add and chain as many as you like.

Cheers

Michael

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Darryl
Collins
Sent: Wednesday, 8 July 2009 2:42 PM
To: 'Discussion concerning MS SQL Server'
Subject: [dba-SQLServer] Run a DTS package from another DTS Package

Hi Folks,

Due to user restrictions at work we have to jump thru many hoops to
automatically schedule a DTS package to run.  To this end we use 3rd
party software called "control-m".  The control M agent is set up to run
a DTS package on SQL Server (2000 in this instance).

As the agent can only call one DTS package at a time and I have many I
need to run, I want to be able to get Control M to call one DTS package,
and that package in turn will execute all the other DTS packages I
require.

Been poking around on Google without much luck. Everyone seems to assume
I can just "schedule" the existing DTS in SQL server, which I cannot.

Anyway... Can anyone help point me in the right direction with this.

cheers
Darryl.

This email and any attachments may contain privileged and confidential
information
and are intended for the named addressee only. If you have received this
e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because
this e-mail
has been sent to you in error. It is your responsibility to check this
e-mail and
any attachments for viruses.  No warranty is made that this material is
free from
computer virus or any other defect or error.  Any loss/damage incurred
by using this
material is not the sender's responsibility.  The sender's entire
liability will be
limited to resupplying the material.


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list