Is it possible to load a blank or empty file with a data pump task? We have
a process that loads multiple files, and sometimes they contain data and
sometimes they don't. We don't know which files will contain data and which
ones wont. Instead of creating multiple packages to handle every possible
scenario, is it possible to have the source file in a data pump be blank and
have it load 0 rows to the destination table?

Any help is appreciated.

Another option is when you loop through the files, check the
file size to see if it has data and should be imported.

-Sue

On Thu, 26 Jan 2006 12:20:02 -0800, "Andy"
<Andy (AT) discussions (DOT) microsoft.com> wrote: