Login to the physical SQL server machine and run enterprise manager from there. And make sure the user your connecting with and setting up the DTS as is the database user. Even doing it as the SA I found it didn't work.
-----Original Message----- From: Crow T. Robot [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 23:28 To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? I saw that. Can you expand a little bit on what you mean? I guess I don't quite understand what you mean when you say: login as the DBO of the database I want to install the DTS on and do it from there. Otherwise it will not run. I'm logged on as the DBO on my workstation, but....? This seems simple, but I swear, I'm losing something in the translation. Snake wrote: > 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:247714 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
