Validate Parameter value in expression

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  April 9, 2008 at 12:23 pm

  #121586

  Hi ,

  I have this situation,I need to store results of a Select Count(*) from TableA to a parameter and only if the value of the count(*) is greater than 50,000,a notification mail would be sent out to the table owner.Currently this is what I have done:

  1) Use SQL task to include "Select Count(*) from TableA"

  2) In parameter mapping tab of SQL Task, define the following

  Parameter name : User::Count

  Direction: Input

  Data Type: Numeric

  Parameter Name : @Count

  3) I have connected the SQL Task to a Send Mail Task [ Only If @count>50 000, then a mail should be sent out]

  4) The constraints has been set as

  Evaluation Operation : Expression and Constraints

  Value: Success

  Expression : @Count >"50000"

  In SSIS tab > Variable

  I have set the following

  Variable Name : Count

  DataType : Int32

  Can someone advise me where I am going wrong, as when I execute the

  Package regardless of count of records > or < lesser than 50 000,mail is still sent out.

  Thank You in Advance

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  April 9, 2008 at 1:31 pm

  #800600

  Got it solved by http://support.microsoft.com/kb/906547 .

  Thank You

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]