DTS : RAISEERROR after select statment

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

DTS : RAISEERROR after select statment

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-05-20 : 04:32:39

i am raising an error in a DTS and it works fine
but when i try to update a global variable , the RAISE ERROR dosent effect any more!


Declare @RowCount as bigint
Declare @Msg char(100)

set @RowCount=count(id) from TempTable
set @msg='DTS Package : TempTable Has Reached , size = '+LTRIM(RTRIM(cast(@RowCount as varchar(50)))) + ' Rows '
select @msg //***** LINE THAT MAKES THE PROBLEM
if RowCount  >10
	RAISERROR (@msg, 50000, 1)  with log

LINE THAT MAKES THE PROBLEM ==>> if i remove the line the raise error works fine, if i putit back the raise error has no effect - any idea why?
thnasks i nadvance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources