Re: Bypass step when source file empty
From: Isak Dinesen (no5pam_at_hotmail.com)
Date: 05/17/04
- Next message: Curt: "DTS Loging"
- Previous message: John Miceli: "Re: How does one query the status of the last batch during the DataPump Batch Complete phase?"
- In reply to: K: "RE: Bypass step when source file empty"
- Next in thread: Quentin Ran: "Re: Bypass step when source file empty"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 17:45:53 GMT
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@discussions.microsoft.com> wrote in message
news:EC179561-DAE0-4E33-ABFF-C6001EEF417A@microsoft.com...
> Hello Quentin,
>
> You could achieve this via an active x script. Please read more about
"FileSystemObject"s.
>
> hth,
> K
>
> ----- Quentin Ran wrote: -----
>
> 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
>
>
>
- Next message: Curt: "DTS Loging"
- Previous message: John Miceli: "Re: How does one query the status of the last batch during the DataPump Batch Complete phase?"
- In reply to: K: "RE: Bypass step when source file empty"
- Next in thread: Quentin Ran: "Re: Bypass step when source file empty"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
