Migrate data from Oracle 9i Database to Sql Server 2005 database
Hi, I have 600 plus tables in oracle database and I have the same database skeleton with same names in sql server. My task is to migrate the data from oracle to sql server using SSIS. Can anyone please suggest me any solution which does dynamic mapping (Tables to Tables and Column to columns) by giving the source and destination Database names. Thanks, Chiran
June 28th, 2011 11:51pm

The easiest approach in my view is to use the Data Import Export Wizard. The end result can be saved into a package that you can later modify as you wish.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 11:55pm

Hi, I too have a similar situation. I'm getting an error if i use Import and export wizard because most of the source tables contain blob, clob and long raw data types. How do we build a package for tables which contain the above datatypes???
July 5th, 2011 5:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics