Remotely executing a DTS from ColdFusion

ColdFusion Add comments
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.

1 response to “Remotely executing a DTS from ColdFusion”

  1. - Says:
    select @execcommand = '"dtsrun /S'+@hostName+' /Uuser /Ppassword /N'+@package+'"'
    exec master..xp_cmdshell @execcommand

Leave a Reply

Leave this field empty

Powered by Mango Blog. Design and Icons by N.Design Studio