Debugging in SSIS

.net sql-server debugging ssis
Gnana picture Gnana · Mar 17, 2009 · Viewed 15.4k times · Source

How do I debug .NET code written within a script task in a SSIS package? The development environment allows placing a breakpoint however does not take me to the code like it would in regular .NET programming while debugging.

Also, I am at a loss to understand how to add the SSIS package variables to the debug watch window?

Currently one thing I figured was the use of msgbox. But thats no substitute to a full fledged debugging using the development environment. Any help is appreciated. Thanks.

Answer

Gabriel Guimarães picture Gabriel Guimarães · Aug 27, 2010

Note: If you are running on x64 you must change the project (SSIS) Debug propertie Run64BitRuntime to false.

After that you'll be able to debug a script task in .net, and break code in the script.

By the way John Sansom dont appear to have read this part of the question: How do I debug .NET code written within a script task in a SSIS package? Its a script task, not normal SSIS debugging.

Hope this helps.

Related questions

how to insert datetime into the SQL Database table?

How can I insert datetime into the SQL Database table ? Is there a way to insert this query through the insert command in C# / .NET?

Read More
C# Equivalent of SQL Server DataTypes

For the following SQL Server datatypes, what would be the corresponding datatype in C#? Exact Numerics bigint numeric bit smallint decimal smallmoney int tinyint money Approximate Numerics float real Date and Time date datetimeoffset datetime2 smalldatetime datetime time Character Strings …

Read More
How can I solve a connection pool problem between ASP.NET and SQL Server?

The last few days we see this error message in our website too much: "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and …

Read More