Well, that's kinda f'ed up, huh? Worked like a charm. Thanks for the heads-up.
Snake wrote: > 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:247716 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
