Running 32-bit SSIS in a 64-bit Environment
Posted
by John Paul Cook
on SQL Blog
See other posts from SQL Blog
or by John Paul Cook
Published on Thu, 25 Mar 2010 02:54:37 GMT
Indexed on
2010/03/25
3:03 UTC
Read the original article
Hit count: 426
Filed under:
After my recent post on where to find the 32-bit ODBC Administrator on a 64-bit SQL Server, a new question was asked about how to get SSIS to run with the 32-bit ODBC instead of the 64-bit ODBC. You need to make a simple configuration change to the properties of your BIDS solution. Here I have a solution called 32bitODBC and it needs to run in 32-bit mode, not 64-bit mode. Since I have a 64-bit SQL Server, BIDS defaults to using the 64-bit runtime. To override this setting, go to the property pages...(read more)
© SQL Blog or respective owner
