I need BIDS/VS to be able to recognize the 64 bit ODBC Data Provider for Oracle. Right now it will only recognize the 32 bit ODBC Data Provider for Oraculous.
BIDS is based on Visual Studio, which as of the current release is only available as a 32bit package. When the SSIS package runs, it will run as a 64bit process (if launched by the 64bit version of DTEXEC.exe) but all the designing must be done within the 32bit environment. This includes the current public CTP release of SQL Server "Denali" which uses Visual Studio 2008.