Groups | Blog | Home
all groups > sql server dts > january 2006 >

sql server dts : Load empy file


Andy
1/26/2006 12:20:02 PM
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?

Sue Hoegemeier
1/26/2006 8:36:16 PM
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"
[quoted text, click to view]
AddThis Social Bookmark Button