Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Wardy_Wonderland
Starting Member
3 Posts |
 Posted - 2008-12-08 : 18:32:04
|
| 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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 03:02:54
|
| i would have use for each loop container to loop through 50 dbs and use OLEDB source inside. Then i will use conditional task to only populate valid date valued records to destination. the invalid records can be sent to file or table which can later be corrected.You can use expression builder to dynamically change connection property of OELDB source and destination. |
 |
|
|
|
|
|
Importing Multiple Oracle Tables.