Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United Kingdom (Proper English-like)
Skip to locale bar
Wiki
>
TechNet Articles
>
Article
History
How to Use Microsoft Oracle Source Component by Attunity - TechNet Articles - United States (English) - TechNet Wiki
When we want to work with Oracle in SSIS, we can use the Microsoft Oracle Connector. It's better than other resource.
First we must download it here:
http://www.microsoft.com/en-us/download/details.aspx?id=29283
After we install it, we must add it to a list in SSIS.
Choose Toolbox Items-->SSIS Data Flow Items
Now we can use it in an SSIS package.
In the data flow, add the Oracle source and set config.
First we must create a connection to the Oracle database:
When you set the connection and test it, click OK. We can select your data:
Now you have data in the data flow, and we can use it.
It is for source Oracle and Oracle Destination.
Related topics to write about:
Dynamic query with an Oracle source.