I want to write a neat SSIS to automate the monthly load of 250 MS Sql Server Tables to the Oracle 10g database. Now, I know how it works but I dont want to create 250 data export/import steps. Is there a that the SSIS captures the schema, does the data
type conversion and dumping automatically? I know Oracle SQL Developer does this whole "schema capturing" but it lacks automation.
View Complete Post