Table A is created in an Oracle d-base randomly every day...sometimes 5 am
sometimes 11 am...very unpredictable. Every day when the query is run that
builds the table, it overwrites the previous day. Once I successfully import
the table I can fire my scripts. Right now I've been doing all this manually.

I know how to schedule a DTS, problem is as follows:
1) If the Oracle warehouse hasn't run the query, the info is from the day
before yesterday. I certainly don't want to load my SQL database w/
duplicate info.
2) If the Oracle load is in the process of creating my new table and the
DTS runs, it will create a blank table. Problem with that is that that the
conditions on scheduling scripts won't recognize the blank table as a
"failure" and will proceed w/ running the scripts.

How can I successfully import the table from Oracle into SQL and run my
scripts after validating that yesterday's data exists and stops if it
doesn't? I'm open to any other ideas...

Thanks so much for offering any suggestions!!!
tag

Hello tag,

The easiest way for you to do this is have the oracle process drop a flag
for you when it is finished. Perhaps it will write a file for you and you
watch for the file.

Allan