I have a problem on migrating a package from from dev to production env. Migrating package from Vista + Sql 2008 to W2K8 + Sql 2008. Connecting to oracle provider. Using oracle 11 client (installed same driver in both machines) [Connection manager "ERP"] Error: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider MSDAORA.1 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Can test, can preview data, get error when we want to run the package. Can anyone help? Thanks

Have you tried to confirm it is 64bit issue, by running your package with 32bit DTEXEC ? Check also Oracle Destination component.

Hi, The package wont run, even when I type DTEXEC /F package.dtsx on command prompt. I did notknow about the oracle destination component, however, I am trying to read from oracle and write to my DW on SQL server 2K8. The package runs fine in my Windows Vista environment (development) but wont run on the server. So I am looking for environment problems. I tryed both 32 and 64 bits oracle client, but the 32-bit client is the one that gets closest to fullfilling the task so far I. I cannot even create a connection when 64-bit client is installed.

This is a weird error:Have you seen these posts:http://social.msdn.microsoft.com/Forums/en-US/netfx64bit/thread/a637b3b2-e570-4435-b8f2-0aaa642d0e3a/http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=262927&SiteID=1I have another question. I see that you are trying to use Microsoft Oracle driver. Have you tried using:Oracle Provider for OLE DBOracle Data Provider for .NETOracleClient Data ProviderOracle ODBC driverLet us know, which one helped.

Oracle provider for OLE DB [Connection manager "orassv.ssv.local.dba_cel1"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x800700C1.An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x800700C1 Description: "%1 is not a valid Win32 application.". Oracle Data Provider for .NET [ADO NET Source [448]] Error: System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) I dont know how to create a Oracle Client Data Provider. I could not create ODBC connection for the oracle driver is not installed (??) I do not haveHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOME key to check for the oracle address. I should have gone online today. No solution so far. All connections are working on DEV environment we also tryed Oracle Provider and Oracle .NET provider and both work. On DEV environment (Vista) there are the mentioned keys on registry

Miguel,This errors look like you are trying to use 32bit providers in 64bit mode. Are you sure you have the correct components installed?Another question. When you installed the component, did you run the installation in privileged (administrative) mode. Windows 2008 does by default run the installations in limited mode, resulting in partially installed applications.

To run the 32-bit version of DTEXEC, you need to use the version in the Program Files (x86) folder. Code Snippet"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe"

You might also check out Microsoft Connector for Oracle by Attunity http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en

CozyRoc, I do believe I have all apps installed on 64 bit version. Except oracle client, wich wont work at all. (maybe thats my problem?) jwelch It did not work with DTexec: Code Snippet "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" I always get the same error, by running on SSIS or DTEXEC. weehyong I got a different error when using Microsoft Connector for Oracle by Attunity. I liked it for it looks simpler then OLEDB provider. hope it is really faster, will be a great discover. [Connection manager "Oracle Connector 1"] Error: Oracle Home not found. Now, I can still preview data. I re-built a very simple dimension process package for this taks. It is called Dim_Storages. I am reading Storage code and storage name only (makes it easier to re-build several times) and send it to a destination table without any treatment (i hand-delete table content prior to running) However, my problem is related to oracle client for W8K64 to use with SSIS (SQL 2K8 64). I have already tryed oracle client 10G and 11G 32 and 64bits (64 bits wont work at all SSIS wont recognize that it is acctualy installed). This is the error message given when using the 64 bits client for W2K8 oracle 10G: Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. I have now tryed several connection methods and a couple of SSIS source components (OleDb and Attunity). All products were (some days ago) on a clean install.

Miguel,Most of the problems we have seen so far can be traced back to incomplete installation of Oracle client components for 64bit machine. I would like to suggest that you also post back at Oracle forums because there might be more Oracle specialists available there, who can assist with these issues.

Hello!!! Great news from Brazil!!! http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=449593&SiteID=1 Oracle Bug id=3807408 If there are parentesis in your app instalation folder try relocating it!!! Is it possible for me toinstall SQL Server without (x86) on the path? (I'll bet it isnt) I ran a package today for the first time on our new server by typing: C:\PROGRA~2\Microsoft SQL Server\100\DTS\Binn\DTEXEC /F c:\myproject\mypackage.dtsx Now, I will schedule all my packages to run untill I can actually solve the issue. I am not willing to rest with this as the only solution ( really cant stand that my problem was a parentesis). Anyone with metalink account could actually check the bug status on oracle (I cant, my support ended last year)! I am posting everything here and at comp . databases . oracle . server forum so hopefully someone will help. Any news and I will post it here!

Answer on oracle groups: "I wonder if microsoft realizes that users who publish metalink notes on their forums are committing intellectual theft?" Well I will need a different solution then... Not countingwith oracle experts anymore. Very sensitive subject.

Miguel, How is the progress on this? Did you manage to solve it?

Miguel Salles wrote: Now, I will schedule all my packages to run untill I can actually solve the issue. I am not willing to rest with this as the only solution ( really cant stand that my problem was a parentesis). Accept it as an Oracle bug. http://joeydotnet.com/blog/archive/2007/01/24/19.aspx

No progress so far. Now I am having problems on development for the DEV computer is on maintenance and I am using the production server for DEV.Really upset, always running thru some c:\progra~2\...Logs are hard to read, development is quite tiresome.Att.,

Hello everyone... i have a question in regards to oracle compatibility... is oracle 6i compatible to 64 bits machine and OS windows server 2008??? Thanks a million for your assistance everyone.