locked
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?

    Thanks!

    Tuesday, March 13, 2018 5:30 AM

All replies