SSIS and Sql Server Journey

Personal Notes of Sarabjit Singh and Bhavpreet Singh

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

on April 5, 2013

maxt2posh

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

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 . 

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

🙂

View original post

Advertisements

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

%d bloggers like this: