On Failure WorkFlow not getting Exectuted

i created a DTS package in SQL 2000 using the enterprise manager.

I have defined a SQL task to drop some temporary tables on failure of another SQL task. Also the same temporary tables need to be dropped on success of another task. the on success workflow is working fine. but when i add the on failure workflow to the temporary table dropping task, the temp table droppin is not getting excuted at all either for success nor for the failure. please help me out.

So multiple conditions are pointed to the same failure "workflow"?

If so, change the Multiple constraints option on one of the precedence constraints from the default of "Logical AND" (all constraints must evaluluate to true) to "Logical OR" (only one constraint must evaluate to true).|||Logical OR is great feature in SSIS, but I think the question is about DTS 2000, which did not have this option. In DTS 2000 you need to duplicate error-handling tasks. Or move to SSIS :)|||It worked when i duplicated the error-handling tasks..

OLE DB Destination Table/View Drop Down

Is there any way around (or will there be) using the drop-down? It takes several minutes when running against an Oracle Apps database to populate that dropdown with the several hundreds of tables and views.

TIA.

Yes, just write a SQL statement instead. You should be doing this anyway to be honest, selecting from the dropdown is very bad practice.

-Jamie

|||

For an OLE DB Destination? I always write SQL for the sources, but don't quite follow how to do that for a destination.

Thanks for the quick reply!

-Chad

|||

DAMN. You said Destination. Sorry, I should read posts more clearly.

However, you can still do this. Just select 'SQL Command' as your Data Access Mode and your SQL statement just selects all the columns that you want to insert into from the table that you want to insert into.

Ignore what I said about best practice though. its best practice for sources, not destinations.

-Jamie