How to run an SSIS package from C# .NET 7?

Question

How to run an SSIS package from C# .NET 7?

I saw the following article

https://learn.microsoft.com/en-us/sql/integration-services/ssis-quickstart-run-dotnet?view=sql-server-ver16

but it seems it cannot be applied to .NET 7.

It has the following step

In Solution Explorer, right-click the References folder and select Add Reference. The Reference Manager dialog box opens.

but there is no References folder and Add Reference option in a .NET 7 project.

Answer 1

Hi @Maxim Eliseev,

There are many ways how to launch SSIS packages.

One of them is via T-SQL. So, you can create a stored procedure (SP) that will launch SSIS packages. After that just call that SP from C# .NET 7.

For the reference: https://learn.microsoft.com/en-us/sql/integration-services/ssis-quickstart-run-tsql-ssms?view=sql-server-ver16

Answer 2

Hi @Maxim Eliseev,

I'm not familiar with C#.

Check it out here to see if it is helpful.

How to execute an SSIS package from .NET

Execute SSIS Packge by using C# and SQL Server

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

but there is no References folder and Add Reference option in a .NET 7 project.

Then you may have create a wrong project type in Visual Studio.

Create a new one and ensure you have selected a .NET (not core!) WinForms/WPF or similar project type.