Last post Mar 14, 2018 07:22 AM by Eric Du
Mar 13, 2018 05:30 AM|klgrube|LINK
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?
Mar 14, 2018 07:22 AM|Eric Du|LINK
According to your description, please check the following tutorial, this quick start tutorial demonstrates how to write C# code to connect to a database server and run an SSIS package:
Run an SSIS package with C# code in a .NET app: