Importing Multiple Oracle Tables.

[WardyWonderland]

Hi guys,

I'd be very grateful if someone could give me a bit of advice on how to approach a job I have to undertake.

I need to import around 50 tables from an Oracle database to SQL 2005. What would be the best way to achieve this? The problem I have is that in some tables there are some dates that SQL will reject ie. a date of birth as 01/12/197.

Should I create a package using the Import wizard and then where I have incorrect dates change the source to use a SQL query ? or is there another way that would be a better choice? Would you create 50 data flows? or could you use a loop container with variables from another table?

I'd be grateful for any advice, many thanks.

Peter.

 

[williey]

Start with the SSIS Import and Export Wizard. The tool will create the flow for you. You may have to fine tune the flows as you test out.

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[MDXer]

use the TO_Date function in ORacle and see format them to a MS SQL accepted format.