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