Re: Bypass step when source file empty
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 05/18/04
- Next message: Loic: "Re: Email triggered task"
- Previous message: test: "RE: Progress Database"
- In reply to: Quentin Ran: "Bypass step when source file empty"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 22:34:07 +0100
In message <uitQD$BPEHA.2920@tk2msftngp13.phx.gbl>, Quentin Ran
<ab@who.com> writes
>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
>
>
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
- Next message: Loic: "Re: Email triggered task"
- Previous message: test: "RE: Progress Database"
- In reply to: Quentin Ran: "Bypass step when source file empty"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
