Yea, the procedure that is explained here: http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS
traps any errors. I am using this exact code, pretty much cut and pasted, with the server and password changed. Robertson-Ravo, Neil (RX) wrote: > 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 <[email protected]> > 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:247707 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
