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.
Asked
Active
Viewed 67 times
1 Answers
1
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.
mrdenny
- 27,174
- 4
- 41
- 69
-
Denali uses 2010 IIRC ;) Or? ;) – TomTom Jul 11 '11 at 05:44
-
SSMS for "Denali" is based on Visual Studio 2010. BIDS is based on Visual Studio 2008. When the next CTP is released that may all change. – mrdenny Jul 11 '11 at 20:02
-
SQL Server "Denali" CTP3 (which was released this morning) using VS 2010 for BIDS. – mrdenny Jul 12 '11 at 19:42