October 16, 2012 at 4:12 am
Hi all,
In the past I have had issues when trying to connect to Oracle database via SSIS within SQL 2008 SSIS on a 64bit platform, this was always down to the lack of drivers with SQL.
I am now testing this again with SQL 2012 64bit and cannot connect still. Is there a way of forcing this to work. I need to connect to an Oracle database to migrate data into SQL Server.
Any help really appreciated.
Thanks
October 16, 2012 at 4:18 am
I'm not sure if anything has changed in 2012, but in 2008, BIDS/Visual Studio will only run debug in 32-bit, so you need the 32-bit drivers installed as well to run the package through the IDE.
When you run the package in production through a job schedule/DTSExec, it will then run in 64-bit and use 64-bit drivers (unless you use the 32-bit option when running it)
November 5, 2012 at 5:14 pm
A related, recent post:
http://www.sqlservercentral.com/Forums/Topic1375169-364-1.aspx#bm1375221
I think SSDT 2012 (built on VS2010 Shell) is still only available as a 32-bit app so if using an Oracle ODBC driver you'll need to create a 32-bit DSN for local dev and a 64-bit DSN on the server to support your deployment.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply