[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.