Darryl Collins
Darryl.Collins at coles.com.au
Wed Jul 8 21:27:10 CDT 2009
aaah, Taking this approach seemed to have worked (well, so far - I can certainly run all of the packages by executing a single DTS package). Next step is to see if I can get Control-M to execute the single package ok - which is another issue outside of the scope of this list. Looks promising though. Many thanks for this - probably obvious I guess, but I am still pretty green around parts of SQL Server that I don't use daily so your help is really appreciated. cheers Darryl. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Michael Maddison Sent: Thursday, 9 July 2009 10:59 AM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Run a DTS package from another DTS Package 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com 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.