February 17, 2008 at 2:36 pm
Hi,
Urgent need help from anybody reg.SSIS Packages on 64 bit
We are currently facing the problem with building 64 Bit SSIS pacakages(located on DB Server..which is 2003 Server Edition, 64 Bit) with connecting 32 bit oracle(loaded on the App Server..Windows 2003, 32 bit) in Business Intelligent Development Studio(Integration Services) with Sql Server 2005 64 Bit. We have installed 64 bit Oracle client and network tools and drivers on Database Server(DB Server), but we are still unable to connect from to Oracle from the BIDS for making the 64 bit SSIS packages.
Please give guide me towards the steps for testing SSIS packages which are in 64 bit Using XML files?
how to proceed towards making these packages??
Thanks
John
February 19, 2008 at 12:11 pm
I haven't tried creating an SSIS package on our Windows 2003 x64 server using Oracle 8 or 9i driver, but I kow that linked servers won't work. The 64-bit operating system doesn't have an OLE DB for ODBC driver so you'll need to try something else. I've seen a couple of threads where some people were able to use the native Oracle 10 or 11 OLE DB driver so you might try those. I haven't downloaded the drivers and tested so if you're successful, please post. Good luck.
March 1, 2008 at 8:57 pm
As I understand your problem, you are trying to develop on a 64 bit machine after installing only the 64 bit version or Oracle. If that is correct then you can not do this with BIDS.
BIDS is a 32 bit application, therefore it tries to run the 32 bit Oracle driver even on a 64 bit machine. If you install the 32 bit Oracle driver on your machine you should then be able to develop there. However I highly recommend developing on another machine and keep your development and production enviornments separate.
Mark Sullivan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply