SSIS event handling - 'resume next' equivalent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kent.eilers@res-direct.com - 27 Jun 2008 15:44 GMT

i've googled and reviewed the event handling chapter in my wrox SSIS
book..but have not found the equivalent of the old 'resume next' vb
statement.

I am creating/droping a temp table for excel imports....need to trap
error for 'drop table' command if table does not exist...and just move
on to next step in flow.

yes..there are other ways of dealing with this...and i'll go there if
i can't do the 'resume next' statement equivalent in this 'execute
SQL task' task's event handler.

Thanks

Reply to this Message

Todd C - 30 Jun 2008 17:14 GMT

Kent:
Why not put the DROP Table statement in its own Execute SQL Task and have
the precedence constraint set to "On Completion" instead of "On Success"? The
behavior will be similar to "Resume Next" because regardless of if the task
executes with error or not, the next one in line WILL get its turn to go.

Signature

Todd C

> i've googled and reviewed the event handling chapter in my wrox SSIS
> book..but have not found the equivalent of the old 'resume next' vb
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message

kent.eilers@res-direct.com - 02 Jul 2008 19:31 GMT

> Kent:
> Why not put the DROP Table statement in its own Execute SQL Task and have
[quoted text clipped - 18 lines]
>
> > Thanks

sounds like a good idea...i actually ended up using
infromation.schema.tables to determine if the temp table exsits...then
using the constraints to direct to next step.

i'm going try your advice too...

Reply to this Message