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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2007-04-29 : 03:33:10
|
| can i make in DTS something like :if result of "select count(id)" >=10000 thenexecute some vbscript ?which means if some select return morethen 10000 rows then run a VBSCRIPT file, if not no need tois itpossiblee to do it?is there any other way?thnaks i nadvancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
mattyblah
Starting Member
49 Posts |
Posted - 2007-04-30 : 12:01:47
|
| Why not use the ActiveX Script Task item for DTS? I'd do something like assign a global variable the value from your query, then in the activex script task check the value, if over 10000 then run whatever vbscript you have. |
 |
|
|
|
|
|
DTS and "if" condition