Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 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.

share|improve this answer
    
Denali uses 2010 IIRC ;) Or? ;) –  TomTom Jul 11 '11 at 5: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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.