Toad World® Forums

Handling Empty File


#1

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.

Thanks


#2

I get the same “value cannto be null”. But it doesn’t terminate the automation script, .which is sounds like it is for you.

Try changing the activity to not Stop on Error. This should let the activities continue. I’ll make a CR for the empty file issue.

Debbie


#3

Debbie,

I have ContinueOnError but as soon as it hits that empty file, everything else after it stops working.

Thanks


#4

It doesn’t do that for me. What version of TDA are you using?

Debbie