I have a process that exports tables from one database to csv files and then imports the files to another database. The import fails and cannot recover when it encounters empty files because the source tables do not have data in them.
Here is the info from the log:
Attempted to import 0 rows.
Successfully imported 0 rows.
Value cannot be null.
Is there a work around for empty files? It seems that if the files are missing then it’s ok, the process can go on. There are 150+ tables that I need to import.