I have 3 SQL statements in a Execute SQL task in a DTS package. See below.
There is potential for the 2nd statement to fail sometimes. When this fails I
still want to run the 3rd statement regardless. How can I do that? It seems
to quit when the 2nd statement fails not running the 3rd


declare @Datetime smalldatetime
set @DateTime = convert(varchar(25), getdate(), 120)

Insert into datetimestoptable (tablename, starttime, stoptime, Branch,
Result) Values('SomeTableName', @DateTime, Null, 'Branch6', Null)
go

Execute SomeStoredProcedure --Potential to Fail
go

exececute rInsertTimeofTableComplete @TableName = 'SomeTableName'
go

change the datapump task to completion instead of success, this will
help the step to move forward, regrardless of the outcome of the
previous step....

change the datapump task to completion instead of success, this will
help the step to move forward, regrardless of the outcome of the
previous step....

change the datapump task to completion instead of success, this will
help the step to move forward, regrardless of the outcome of the
previous step....

change the datapump task to completion instead of success, this will
help the step to move forward, regrardless of the outcome of the
previous step....

change the datapump task to completion instead of success, this will
help the step to move forward, regrardless of the outcome of the
previous step....

change the datapump task to completion instead of success, this will
help the step to move forward, regrardless of the outcome of the
previous step....

change the datapump task to completion instead of success, this will
help the step to move forward, regrardless of the outcome of the
previous step....

change the datapump task to completion instead of success, this will
help the step to move forward, regrardless of the outcome of the
previous step....

This doesn't apply as I want all of the sql statements in the same step to
run regardless of failures or not.

I actually figured this out on my own. I wrapped everything in Try Catch
statements is this works just fine.

-Chris


"Maninder" wrote: