So to be clear - you have this working in 32-bit mode through BIDS? If so, what's your connection string look like there? It doesn't have the "12" in it, does it? If it does, then you're not using the 2010 driver... so it's not really working in 32-bit mode.
The trick we're going to have to "learn" here is how to develop on 32-bit, then transition to QA/Prod on 64-bit... wish I had more time to work on that...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.