Cool...I'll check yours out first. Now, of course, I'm off to fight fires that always pop up at the worst possible times. Grrr...
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:247609 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
