Home Forums SQL Server 2005 SQL Server 2005 Integration Services Call SSIS package residing on DB Server from a web application ASP.NET residing on Web server RE: Call SSIS package residing on DB Server from a web application ASP.NET residing on Web server

  • February 15, 2010 at 9:31 am

    #1118846

    vishal.shinde (2/15/2010)

    I have a requirement where I need to call a SSIS package from a ASP.NET application.

    The SSIS package is residing on DB Server (created using BI studio) and client application is on another web server which do not have SSIS or SQL Server installed.

    How can I achieve this and what are the prerequisits for achieiving this. Any help is appreciated. Or is there any other way to achieve this requirement?

    Thanks

    Vishal

    Yes you can run it as a job with a stored procedure but this is double hop so the Asp.net runtime needs permissions in both boxes or you will get null user error.

    You also should run the agent with admin level permission because you can run it as a proxy.

    Kind regards,
    Gift Peddie