sql server dts: Sorry, this is from 12 year DBA, DTS rookie. I have a DTS package whichis
simple. SQL to check for records. If there are rows of data dump to text file
and email. All works, however I need it not to email if the rowcount is 0.
This is where I am stuck

Hello timcronin,

OK so what you will do is

You get the count of rows from the table into a variable using the ExecuteSQL
task

Test in a Script Task for the count of rows/variable value.

You turn on or off the eMail step depernding on your logic.

We do a similar thing here

http://www.sqldts.com/246.aspx


step 4

Here we test for if we have more files and if not then we enable/disable
he steps.


--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]