Hi group,

I have a DTS package where one of the step is to load a flat file into a sql
table. The source file can sometimes be empty. How can I avoid an error
state from this step FOR ONLY THIS (other failure should still be observed)
and continue executing the following steps that have work flow dependency on
this step, when this file comes in empty?

Advise/sample code greatly appreciated.

Quentin

DTS doesn't like 0-byte files, so the simplest way to do this I've found
work around this is to initilize the file with some bytes in the first row.
A good place to start would be outputting a header row, but if you don't
have time to update your legacy systems to do that, there are other options.
For eample, if you are using csv format, put an empty crlf on the first line
(or ,,,,), then define the connection to ignore the first line. If you are
using fixed format, you'll need to put the exact number of spaces on the
first line as is used on all subsequent lines.

HTH


"K" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for the response. However, I could not find a suitable object for
this -- maybe due to my unfamiliarity with the objects. Someone can point
me farther? Thanks.

Quentin

"K" <anonymous (AT) discussions (DOT) microsoft.com> wrote

In message <uitQD$BPEHA.2920 (AT) tk2msftngp13 (DOT) phx.gbl>, Quentin Ran
<ab (AT) who (DOT) com> writes
Try the following articles, but instead of checking if the file exists,
you can check the file size, through the FileSystemObject as per one of
the other posts.

How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org