May 2, 2014 at 6:28 pm
how to load oracle database data to sql server with the help of SSIS
May 2, 2014 at 11:49 pm
First thing that comes to mind is to use the SQL Server Import and Export Wizard from SSMS. (right click on the target sql database->Tasks->Import data) Walk through the Wizard and save as package, then import the package into a SSIS project.
😎
May 13, 2014 at 8:08 pm
Use Oracle Provider for Connection Manager in SSIS
May 14, 2014 at 12:12 am
You create an OLE DB connection using the Oracle OLE DB provider.
Make sure the Oracle client tools and the ODAC components are installed on the development machine.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 14, 2014 at 8:07 am
Koen Verbeeck (5/14/2014)
Make sure the Oracle client tools and the ODAC components are installed on the development machine.
Good point, I forgot to mention it. 😀
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply