Hi Chaps All the above do seem very lengthy routes, trhe route mentioned by Ravo is by far the best practice. I have used this method and can definatly say it is an excellent method.
However make sure you do not remove the 'U' & 'P' prefixes in the '/Uusername /Ppassword' I made this mistake once and the errors received were not to helpfull heh ;) Jose Diaz On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > 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 > > :-) > > > > > > > > > > -----Original Message----- > From: James Blaha [mailto:[EMAIL PROTECTED] > Sent: 25 July 2006 13:38 > To: CF-Talk > Subject: Re: execute a DTS package via Stored Proc? > > All, > > "ColdFusion and SQL Server Permission Integration: Part I" ColdFusion > Development Journal, September 2003, pp. 8-15. > http://coldfusion.sys-con.com/read/42068.htm > > "ColdFusion and SQL Server Permission Integration: Part II" ColdFusion > Development Journal, October 2003, pp. 26-33 > http://coldfusion.sys-con.com/read/42080.htm > > I hope this helps. > > -Jim > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:247600 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
