DTS Package determine if table is Empty - 10-04-2006 , 04:42 AM
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.
Re: DTS Package determine if table is Empty - 10-05-2006 , 09:53 AM
use a stored procedure to run you're package or create a new package with
some sql instructions
set @total = ...select count(*)...
<gavincampbell_uk (AT) yahoo (DOT) com> a écrit dans le message de news:
1159954959.548521.237330 (AT) m73g20...oglegroups.com...