How to Execute a SQL Server Integration Services Package from the SSISDB catalog from within ASP.Net RRS feed

  • Question

  • User-1691979634 posted

    I have created an Integration Services Package that uploads data from SQL Server to a Google Sheet.  The package works perfectly.

    I deployed the package to Sql Server (SSISDB) and I can execute the package from SQL Server just by clicking on the name of the package and clicking "execute package."  It runs perfectly.

    I have created an ASP.Net web page.  On that web page is a button.  The Button Click event should execute the Integration Services Package to upload the data.

    I have only gotten as far as adding a reference to Microsoft.SqlServer.Management.IntegrationServices.  I have been looking for an article or post that describes how to do this within an ASP.Net C# .cs code behind file with no luck.  The articles either refer to file system packages or they are outdated.

    I'm hoping someone here can help.  Any suggestions?


    Tuesday, March 13, 2018 5:30 AM

All replies