Calling SSIS from ASP

migration , ASP , SQLSERVER , SSIS , DTS India
  • 9 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.


Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“There's no test like production” - Anon