It seems like every time I go to run a SSIS package on a 64 bit machine I forget how to set the flag to run the package in 32-bit mode to be compliant with the 32-bit SalesLogix OLEDB provider. Here are the steps:
· Open the package in visual studio
· In the Solution explorer on the right, right click on the SSIS solution you have created.
· Choose Properties
· Click the Debugging choice under Configuration properties.
· Set the Run64BitRuntime = false.