Is this forum moderated?
The ODBC import works great, I would like to be able to run the same import each week to update my data. When I choose to save the import as a sql file it actually saves the insert statements for each individual record instead of the overall operation, eg copy from this table, copy from that, ignore this column, do my work for me, etc.
It would be great to be able to create the job in the ODBC import wizard and have it save the job to a file that I can then schedule to run regularly, preferably from the command line or another method that allows the use of windows task scheduler and no user intervention.