SSIS C# Debugging and Breakpoints not working with Integration Services Object

Question

I have a Integration Services Project with a Script Task. The Script Task Code is written in C#.

I set some breakpoints at different locations in the code, one right at the beginning. The breakpoints are working in general, when I start debugging the SSIS project the VSTA Windows opens and execution stops at the first breakpoint (as it should).

I now try to add the execution of a SSIS package as described here:

https://learn.microsoft.com/de-de/sql/integration-services/ssis-quickstart-run-dotnet?view=sql-server-ver15

I start with the following:

string folderName = "FUNDAMENTAL";
string projectName = "1001_IMPORT_ENTSOE_XML";
string packageNameSSIS = "1001_IMPORT_ENTSOE_XML.dtsx";
string sqlConnectionString = "Data Source=SERVER; Initial Catalog=master; Integrated Security = SSPI;";

SqlConnection sqlConnection = new SqlConnection(sqlConnectionString);

Breakpoints still working.

However, when I add the next line of code, all breakpoints are ignored and the VSTA windows does not open. Instead, the code runs until the end successfully.

IntegrationServices integrationServices = new IntegrationServices(sqlConnection);

Why?

Answer 1

Sorry I am not able to add a comment . Try adding the script code to new console application project and try to run it through there . I think the code is not able to be build . There might be some missing assembly reference. You can easily get the error by debugging the console application. Also try changing the ssis package run 64 bit property.