Viewing 2 posts - 1 through 2 (of 2 total)
Crispin Proctor (8/12/2008)sorry, remove count(Null) and just have null.Select null from table.
Crispin Proctor (8/12/2008)
Select null from table.
That did the trick. Thanks!
August 12, 2008 at 3:39 pm
#857073
Crispin Proctor (8/12/2008)Easiest way would be to use a SQL task and run a check in it.If not Exists(Select count(Null) From MyTable) RaisError("Table is empty!", 16, 1)
If not Exists(Select count(Null) From MyTable)
RaisError("Table is empty!", 16, 1)
This seems to...
August 12, 2008 at 1:16 pm
#856993