Darryl Collins
Darryl.Collins at coles.com.au
Wed Jul 8 21:12:01 CDT 2009
Yeah... I know. The company policy is giving me grief in this area. The annoying thing is I can create the DTS packages and manually run them as often as I want, I am just having a hell time getting the scheduled so they automatically execute once a day. *sheeesh!!* I know it shouldn't be this hard, but due to permission issues, it is. Big company - they are not interested in changing their policy for lill ol' me. If necessary I can make up a control-m agent for each DTS and run them individually, it is just a PITA to have to take that approach. *shrugs* oh well... 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 11:45 AM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Run a DTS package from another DTS Package 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 _______________________________________________ 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.