I'm trying to get my DTS job downloading from Oracle to delay for 3 hours if the I cannot find a specific record in an Oracle table. I tried to use "On Failure" but it doesn't seem to work since nothing seems to fail. What can I do? Thanks for your help

Dave Wong

You can easily set up workflow.

An Example would be.

Active Script task - Check for Row in table
------> row is there then move on to the
DataPump task. Set a Global Variable to Done
------>Row is not there then Wait for 3
hours, retry. (do this in a loop)

You can find examples of workflow here

Workflow
(http://www.sqldts.com/default.aspx?103)


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Dave Wong" <anonymous (AT) discussions (DOT) microsoft.com> wrote

"On Failure" but it doesn't seem to work since nothing seems to fail. What
can I do? Thanks for your help.

Thanks Allan! It works.