|
Home > Archive > MS SQL Server DTS > January 2006 > Load empy file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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.
| |
| Sue Hoegemeier 2006-01-27, 3:23 am |
| 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@discussions.microsoft.com> wrote:
>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.
|
|
|
|
|