I have an odbc for DBISAM, and can use it to import into sql server, but only one table at a time. (when it get's to the choose table screen, it will only let me create a single SQL query.
does anyone know if I can extract from multiple tables using this?
If not - what would I need to change in the DTSX file so that my query goes from "select * from tablea" to "select * from tableb" and the destination table is also "tableb"?
also - can the DTSX file be change to run for multiple tables?
View Complete Post