Migrate from Oracle to sql server

• DuncanM-700131

  Grasshopper

  Points: 18

  More actions

  October 15, 2008 at 7:55 am

  #125211

  Hi

  I need to create an ssis package which will transfer all 500 tables from an oracle database to and sqlserver database. This is going to happen more than once. Is there a method for doing multiple tables in ssis or is there another method I can use, perhaps "sqlserver migration tool" ?

  Can I then launch this within SSIS?

  Thanks

• DuncanM-700131

  Grasshopper

  Points: 18

  More actions

  October 16, 2008 at 3:39 am

  #885695

  Found it.

  ta?

  Duncan