Post reply

Connecting to Oracle 32 bit from SSIS 64 bit on 64 bit Windows 2003

  • November 1, 2006 at 10:52 pm

    #114939

    Hi,

    I am facing a strange issue in our SqL 2005 datawarehouse environment.

    Please see the details

    Our Development Environment

              OS: 32 bit windows 2003

              BI Suite: SQL Server 2005 32 bit

               Oracle 10g(32 bit) is one of our data sources for SSIS.

               Oracle Server is located in another machine.

                Oracle 10g 32 bit(Release 1) Client is installed on Dev server

              SSIS Packages are running fine

     

    Test Environment

            OS: 64 bit windows 2003

            BI Suite:SQL Server 2005 64 bit

            Oracle 10g(32 bit) is one of our data sources for SSIS.

            Oracle Server is located in another machine.

            Oracle 10g 32 bit (Release 1) Client is installed on Dev server

     

    Once we moved all the packages to Test Environment connection to Oracle has been failed.

    Please help.

     

    Thanks,

    Kumar

     

     

     

  • November 6, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • November 20, 2006 at 8:01 am

    #672963

    Sorry I don't have any answers for you - just a similar question.  Migrating from 32-bit SQL Server 2000 to 64-bit SQL Server 2005/64-bit Windows Server and need Oracle connectivity from SSIS - looking for the best client arrangement to accomplish this.  Oracle host is 9i.

    Also can DTS packages migrated from 2000 run as-is once a client is installed??  (ie. without having to be rewritten in SSIS).

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply