Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-11-25 : 02:32:54
|
| 1. i create Execute SQL Task ,SELECT Count(*)AS cnt FROM TABLE i keep cnt in the variable.2. how in the next step i check if the variable (cnt) > 0 ?? i mean with control i need to use?thanks |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-11-25 : 02:52:23
|
| HiGoto success line(component connector its shows green arrow) double click that there you can find expression you can put @cnt>0-------------------------R... |
 |
|
|
|
|
|
pass variable