Michael Maddison
michael at ddisolutions.com.au
Wed Jul 8 20:44:37 CDT 2009
Darryl, You may need to get your network guys to change the SQL Agent permissions to a domain admin account. That should fix your problems :-) Cheers Michael ok... thanks Michael. I will look into this futher today. I was using xp_shell, but it turns out we don't have permissions for that either. Will look at this more. Thanks for your thoughts on this Regards 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. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com