Running SSIS packages from a .vbs file on an ASP page - how to do it for SSIS??

• mr.bullitt

  Valued Member

  Points: 67

  More actions

  February 3, 2012 at 3:51 am

  #250272

  Hi guys!

  I am trying to upgrade an environment from DTS to SSIS. I finshed upgrading packaged and tested they run fine from file system and the Sql Sever 2008 R2 when deployed there.

  Now I just need to be able to run them from .vbs file that is integrated into an ASP page.

  Old/current line in the .vbs files is as this:

  dtsrun="sqlServer", "userName", "password", "PackageName"#~Run package

  This works for running the DTS legacy packages on the Sql Server 2005 - but now that the packages have been upgraded to SSIS (their names are the same) - how do I do similar with SSIS?

  I tried to replace dtsrun with dtexec, but no good 🙁

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  February 8, 2012 at 6:34 am

  #1444470

  For those who stumble upon this thread using Google, there is a more thorough discussion at the MSDN forums:

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/82db8cd4-2b4c-4b4b-b810-fb214b453886

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP