> I have a DTS package that connects to an Oracle Database and pulls
> some information from it with a SELECT query. I then take the results
> and place them in a table on the local SQL server.
>
> The DTS package has been wroknig fine for over a year, but there was
> an over sight on my part. I had no logic checking to see if the
> database existed on the remote server (oracle). The system was offline
> for an extended period of time and when the DTS package ran it dropped
> the table and created it on the SQL side, but I got no data back from
> the query. So I eneded up with a blank database on my SQL server.
>
> I have since placed an Execute SQL Task that runs a simple query
> against the remote oracle database to check it exist. If I get data
> back It goes to the next step (drop table) if it cannot connect it
> ends the DTS package and sends an e-mail.
>
> My question is there has got to be a better way to handle this. For
> instance If I wanted to verify there were atleast 100 records in the
> database before I proceeeded to the next step. I have the query.
>
> SELECT COUNT(ID)
> from table1
> How could I set the logic to proceed with completion if >=100 and to
> fail if <100.
>