Hi,

I have a dts package that i want to execute and I want to execute a
step as long as the table has records. If the table is empty then i
want the package to stop executing and notify.

Doing a select count(*) from tableName will give me the number of
records and if this is 0 then i know my table is empty but i cant seem
to get DTS to through this out as a failure as it parses the sql
statement as ok.

Any Ideas

use a stored procedure to run you're package or create a new package with
some sql instructions

set @total = ...select count(*)...
if @total=0
execute dtspackage

Regards
Nicolas Guinet


<gavincampbell_uk (AT) yahoo (DOT) com> a écrit dans le message de news:
1159954959.548521.237330 (AT) m73g20...oglegroups.com...