sql server dts: 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

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


[quoted text, click to view]
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.
[quoted text, click to view]