QUICKBLOG: Fixing – Can’t debug Script Task using 64bit SSIS…

On our SQL Server 2008 SP1.  This error will come up when debugging a converted SSIS package from 32 bit to 64 bit solution:

Warning: Cannot debug script tasks when running under the 64 bit version of the Integration Services runtime.

Here’s the Solution to fix this issue:

In the SSIS Property Pages (#1), in the “Configuration properties” under “Debugging (#2) > Debug Options”, you need to change the “Run64bitRuntime” (#3) from “TRUE” to “FALSE”(#4)

Then, next time run rebuild and use the debugger, it will work. 

Related source of information:

http://blogs.msdn.com/amitlale/archive/2007/12/11/ssis-64-bit-setting.aspx

http://msdn.microsoft.com/en-us/library/ms141766(SQL.90).aspx

🙂

Advertisements

About maxt2posh

I’m from Puerto Rico, have been working with computers since 1979. Throughout many years, I have worked with SQL Server Technologies, provided support to Windows Servers/Client machines, Microsoft Virtualization Technologies, and build some Visual Studio solutions. I’m a Microsoft PowerShell MVP since 2009 and MVP SAPIEN Technologies since 2010. I speak in most of the SQLSaturday, IT Pro and .NET camps events around the Florida’s State. Also founder of the Florida PowerShell User Group which meeting every 3rd Tuesday evening of the month.
This entry was posted in SQL Server. Bookmark the permalink.

7 Responses to QUICKBLOG: Fixing – Can’t debug Script Task using 64bit SSIS…

  1. Anonymous says:

    Thanks dude. This save me a lot of time.

  2. Alex says:

    Was plagued by this issue too – your post came up first in google – nice one! 😀

  3. Anonymous says:

    Thanks. It fixed my problem.

  4. Dave says:

    You are a legend. Thank you!

  5. Anonymous says:

    Excellent, solved my issue 🙂

  6. Pingback: Calling a .NET method in a SQL Server script | XL-UAT

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s