Didn't work for me, thus why I had to go to the lengths I did. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 10:34 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc?
No, anyone can run it if given the necessary permissions within a proxy account. -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:32 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Don't you have to be the SA in order to do exec master..xp_cmdshell @execcommand I don't remember the reasons, but I couldn't do it the easy way when I tried. I need to do it as a speciifc user who only had access to his own database. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:03 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^....seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = '"dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247733 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
