U could be having the problem I mentioned in my blog post, where you have to login to remote server and set it all up from there. This was the problem I had initially. I used enterprise manager remotely to connect to the SQL server and setup the DTS, and it just did nothing.
-----Original Message----- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 22:37 To: CF-Talk 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:247710 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
