December 21, 2011 at 9:22 am
Hi Guys,
I have few questions, I am pretty much comfertable using SSIS. Most of time my source is Flat File/SQL/Excel or Access and Destination is Flat File/SQL or Excel, but this time my source is Lot of Flat files and Destination is Oracle 10g or may be 11. My quesiton is How i can transfer my flat file to oracle. The procedure is same Flat File ==> to SQl or different.
Please guide me if there is any other or extra step i have to use. Any help would be great or any tutorial reference would be awesome. Thanks in advance.
Rocky.
December 21, 2011 at 12:02 pm
Guys, I thought there is no special way, just use Source (Flat File) and destination is my Oracle DB. Everything is looks ok before i run my package. I test my both connection Flat File and Oracle DB Works fine. After i hit F5 i am having these error.
1) [Oracle Source [813]] Error: The AcquireConnection method call to the connection manager Oracle Connector 1 failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
2) [SSIS.Pipeline] Error: component "Oracle Source" (813) failed validation and returned error code 0x80004005.
3) [Connection manager "Oracle Connector 1"] Error: The ORACLE registry key cannot be opened. Verify that the Oracle Client for Windows x64 is installed properly.
I really appreciate if someone can help me to fix these error.
Thanks.
December 22, 2011 at 2:46 am
rocky_498 (12/21/2011)
Guys, I thought there is no special way, just use Source (Flat File) and destination is my Oracle DB. Everything is looks ok before i run my package. I test my both connection Flat File and Oracle DB Works fine. After i hit F5 i am having these error.1) [Oracle Source [813]] Error: The AcquireConnection method call to the connection manager Oracle Connector 1 failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
2) [SSIS.Pipeline] Error: component "Oracle Source" (813) failed validation and returned error code 0x80004005.
3) [Connection manager "Oracle Connector 1"] Error: The ORACLE registry key cannot be opened. Verify that the Oracle Client for Windows x64 is installed properly.
I really appreciate if someone can help me to fix these error.
Thanks.
Apparently you have connection issues.
Did you install the Oracle client on your machine?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 22, 2011 at 7:57 am
Thanks for your reply, Here is the Solution,
In solution properties, Run64BitRuntime = false.
-----------ANSWERED-------------------------
December 29, 2011 at 5:40 am
Hi,
You can craete the Linked server in you SQL DB and use that for creating your connection manager in SSIS.
But while dumping the data in Oracle, may create some DataType issues
(ex: INTEGER in SQL is NUMBER(10) in Oracle- http://www.sql-statements.com/data-type-differences-between-sql-server-and-oracle.html)
because the data types of SQL and Oracle are different. You must use the data conversion task to convert the data before dumping in Oracle DB.
Good Luck!!!
Regards,
Chandrashekhar
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply