Click here to Skip to main content
14,935,710 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to Load Data From Oracle to MySQL in SSIS??
Posted
Comments
bbirajdar 5-Nov-12 6:57am
   
Study SSIS . It will get you started
ZurdoDev 5-Nov-12 8:53am
   
Add connections for Oracle and MySQL and then create a SQL task and connect them.

1 solution

1.Place dataflow task in Control flow area.

2.Place OLEDB source and Destivation in Data flow area.

3.Remember since you're moving the data b/w two different DB types so we need to include Data Conversion data flow transformation (which converts source DB data type destination DB type). b/w source OLEDB and destination OLEDB.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900