Calling SSIS from ASP

• • Reply

  9 years ago

  by koti_sastry

  Koteswara

  Bangalore,India, India

  Joined 15 years ago

  Hi all,

  I have a DTS package on SQL server 2000 that is being called from an ASP page as follows which works fine.

  set objDTSPackage = Server.CreateObject("DTS.Package") objDTSPackage.LoadFromSQLServer sServerNam, sUID, sPWD,iSecurity, sPkgPWD, "", "", sPkgName objDTSPackage.Execute()

  We are going to migrate the DB to 2008 and DTS package will be rebuilt in SSIS.

  Now, how can I call this SSIS package from the ASP page??

  Thanks in Advance.

  Koti.

  Report abuse