Jan 20
I recently had the requirement to execute a DTS on a remote SQL Server via ColdFusion.
Doing it via CFExecute was the only method I could find in the Books online, and all the ASP scripts I found seem to asusme your SQL server runs IIS or is on the web server your site is on.
Luckily I eventually found this rather handy answer over at pengo works.
http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS
the only caveat I have found is that you cannot do anything remotely to the SQL server.
I found that I had to login to the server, run enterprise manager, login as the DBO of the database I want to install the DTS on and do it from there. Otherwise it will not run.
May 4, 2006 at 3:24 PM select @execcommand = '"dtsrun /S'+@hostName+' /Uuser /Ppassword /N'+@package+'"'
exec master..xp_cmdshell @execcommand