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:247705
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to