> Hi Mitchell,
>
> Thanks for your response. I guess I was not able to clearly explain my
> problem ... I ll try to do it once again:
>
> I have a DTS Package which has 4 steps.
>
> Step 1: Truncates the tables
> Step 2: Loads Data from DAT File to invoice table
> Step 3: Loads Data from DAT File to order table
> Step 4: Loads Data from DAT File to sales table
> Now I have scheduled this as a Job and my job fails if I receive
> "Zero" byte DAT file in any of the Step (2 - 4).
>
> What I need is suppose at Step 2 ... I receive a "Zero" byte DAT file
> ... I want it to skip Step 2 and proceed with Step 3.
>
> I tried options like:
>
> option 1:
> if it is Zero byte I am failing my package (DTSTaskExecResult_Failure)
> and
> on Failure I am making it to flow to Step 3
> Result: Package fails but does not move to step 3
>
> Option 2:
> If Zero byte skip that step and move to next step. The package does
> not
> throw error but it stop their itself.
> Hope this explains you the scenario. What I need is how can jump that
> step and move to next step if it is a zero byte file?
>
> Thanks
> Ameer
> "Allan Mitchell" wrote:
>
>> Hello KhanAmeer,
>>
>> Why do you want to error out? I personally would handle it and turn
>> on or off the following piece of workflow.
>>
>> Did you get your code from here
>>
>>
http://www.sqldts.com/292.aspx >>
>> --
>>
>> Allan Mitchell
>>
http://wiki.sqlis.com |
http://www.sqlis.com |
http://www.sqldts.com >> |
>>
http://www.konesans.com >>> I am checking the size of DAT file using script task and if it is
>>> Zero I am returning that step as Failure
>>> "DTSTaskExecResult_Failure". On Failure it should proceed to next
>>> step and skip the present step.
>>>
>>> But this is not working and the package is getting error out. Can
>>> anyone pls guide how can we handle this.
>>>
