Are you error trapping in your SP? Try/catch in the SQL? What code are you using?
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Ray Champagne <[EMAIL PROTECTED]> To: CF-Talk <cf-talk@houseoffusion.com> Sent: Tue Jul 25 22:37:07 2006 Subject: Re: execute a DTS package via Stored Proc? OK. So, I got Snake/PengoWorks' solution to work. Kind of. The script runs with no errors, but the DTS package doesn't actually do anything. When I run the DTS from Enterprise Manager, it runs fine. But when I run the script from CF, no errors, nothing. Anybody have any pointers as to where to look next? I've checked my permissions, and they all seem to be fine, and no matter, I was under the impression that the SP would throw an error if there were permission errors. ??? Snake wrote: > Well the way I did worked for restricted user access. Where the user is DBO > of his own database and nothing else. > > Russ > > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: 25 July 2006 14:57 > To: CF-Talk > Subject: Re: execute a DTS package via Stored Proc? > > Yea, that's been my problem. I am the SA on my dev server, but I'm not > going to be when this goes into production. I have about 5 solutions in > front of me, all of which require certain degrees of Administrative power. > Trying to figure out which is the one that will work when I go live is the > hard part. > > I'll look into all these solutions this week. I certainly appreciate all > the choices. > > Ray > > Snake wrote: >> 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:247706 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
