Is it possible to import multiple files to multiple tables in one project? Or do you need one project per import?
I have existing tables in SQL Server and every month we truncate the tables and import new data to them.
I'm using a trial version of ApexSQL Pump at the moment and when I tried to import 2 files to 2 tables at the same time, it only imported the 2nd file.
No warnings are listed and it allows the import to run. Any help would be greatly appreciated.
Thanks