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.
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 ] 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.
In solution properties, what do you have under Run64BitRuntime? Switch to false.
Awesome, Its works fine.
Can you refer me any document where they mention, SSIS data types vs Oracle Data Types?
Glad to know your problem is solved.
Take a look to BOL. Scroll down to Mapping Integration Services Data Types to Database Data Types.