Philippe Maupoil
Member
I have about 70 tables to import using the ODBC importer utility.
I was just testing it with one table by creating my mapping and then save the definitions in a xxx.def file.
I opened the file to see all the parameters and was quite happy to see:
- the mapped columns
- the target table details
- the source tables details (db, schema, table...)
I closed the ODBC importer, connected to the source DB from the 1st tab in the connections details, then opened the definitions file and finally clicked on the "IMPORT" button.
Got 0 records inserted! It looks like I have to manually reselect the source table...
My question is the following: what is the point of having the source table db details if I still have to select it when opening the definitions file?
I was just testing it with one table by creating my mapping and then save the definitions in a xxx.def file.
I opened the file to see all the parameters and was quite happy to see:
- the mapped columns
- the target table details
- the source tables details (db, schema, table...)
I closed the ODBC importer, connected to the source DB from the 1st tab in the connections details, then opened the definitions file and finally clicked on the "IMPORT" button.
Got 0 records inserted! It looks like I have to manually reselect the source table...
My question is the following: what is the point of having the source table db details if I still have to select it when opening the definitions file?
