DCSIMG
המידע שקיבלת במסגרת בלוג זה הינו מידע כללי בלבד ואין לראות ו\או להסתמך על מידע כאמור כייעוץ ו\או תחליף לייעוץ מכל סוג שהוא ו\או להסתמך עליו לעניין כלשהוא. Running SSIS on 64 BIT ITANIUM and read from ORACLE - Business Intelligence,Technology, Thoughts, Thinking
Sign in | Join | Help

Running SSIS on 64 BIT ITANIUM and read from ORACLE

Published at Apr 13 2008, 09:20 PM by Ronen Chenn | 1 comment(s)

Hi ALL,

Those of you who has no other choice but running SSIS on 64 BIT ITANIUM which is not so nice..., should try this settings:

1. Install ORACLE (64-bit) 10.2.0.3 for Windows x64. (latest patch)

2. Define at the environment variable the path to ORACLE HOME .

3. If you had scripts written on 32BIT , you have to compile them on 64 bit, a typical workaround is to open them and define recompile=true on the target machine.

4. If the source table has a Numeric or Currency data type, try to transform them into string and then to the MSSQL correct data type.

Finally, don't give up during the process, there is a rumor that sql2K8 will have the driver!!!Stay tuned,

Ronen

תגים:,

Comments List

# re: Running SSIS on 64 BIT ITANIUM and read from ORACLE

Published at Monday, April 14, 2008 1:56 PM by Arie H.  

Just to add to your post,

I've spent couple of weeks trying to resolve the issue of oracle client ontop of x64 to allow both Linked Server to work and SSIS.

Problem is Oracle client.

Second issue is the fact that Linked Server is part of the x64 SQL code, yet SSIS is a 32 bit application so to make sure both work, you need to follow this procedure:

1. Make sure Windows 2003 x64 is at least at SP1, SP2 preferd.

2. Make sure SQL 2005 x64 SP1 is instlled at least, SP2 preferd.

2. We use Oracle 10gr2, so im refering only to those downloads. Download the Oracle Client 10gr2 - both x32 client and x64 client.

Then proceed to downloading 10.2.0.3 patch set 2, for both x32 and x64. This is the update that finaly deals with the inherit bug in the oracle client that cant handle the fact that in x64 OS, MS has used () in the folder name, ie: C:\program files (x86).

Make sure to install in the percise order:

* Oracle x32 client

* Oracle x64 client (becuase there are 2 oracle client installation, youll need to use 2 different OraHome, thus make sure both OraHome are on the PATH env. variable, install them in different locations, i even went and installed it on different logic drives)

* 10.2.0.3 patch set 2 for x32

* 10.2.0.3 patch set 2 for x64

last to do item is setting up ODBC, becuse SSIS is a 32 bit application running on top of x64 OS, there are 2 ODBC management consoles you'll have to work with. ODBC connection you create in the x64 ODBC manager are not seen by SSIS, you'll have to create them in the x32 ODBC manager.

The x64 ODBC manager is in the normal location - Administrative Tools - ODBC

The x32 ODBC manager is in the x32 enviroment -

c:\windows\syswow64\odbcad32.exe

Note: I used x64 as we dont use Itanium but it doesnt matter much to the issue at hand. Only thing that needs changing when dealing with Itanium is compatability and avilability of the patches to support Itanium, both for MS products and for Oracle Clients and equivalent patches.

Hope this helps bit more ^^

Arie H.

Leave a Comment

(required) 
(
required
) 
(optional)
(required) 

Enter the numbers above: