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-05-16 : 07:16:07
|
| i have a TDS and i want in one of the steps to exit for example if i have more then 100000 rows in a certain table - how can i do this?and how can i do the same in a JOB to check the same and only if i ok then to go to step 2 else to exit!thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-05-16 : 07:18:52
|
| In both cases just raise an error.In the job only go to the next step on success, in the package make sure the workflow is on success to proceed.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2007-05-17 : 02:55:31
|
| this is the way to raise an error that will write to the EVENT VIEWER TOO!RAISERROR ('daniela your bored and only smoke all day long', 50000, 1, 'dddd') with logIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
|
exit a DTS in one of the steps