Checking the number of Rows in a result set returned by Execute SQL task

• bnarav

  SSC Enthusiast

  Points: 104

  More actions

  July 16, 2008 at 5:38 am

  #188189

  I need to check the number of rows in a result set returned by a query in execute SQL task and execute different flows based on the number of rows. Please let me know the steps for doing this.

  Thanks

• SrikanthSv

  Ten Centuries

  Points: 1197

  More actions

  July 18, 2008 at 6:00 am

  #844949

  In execute Sql Task options

  Set the followng options

  Result Set: Single Row

  In the parameter mapping tab

  map the result set to a variable

  The variable will be assigned with the number of rows effected

  to get the no of rows effected from the sp or the function

  use the following statement

  Select @@ROWCOUNT

  Regards
  Venkat
  http://sqlblogging.blogspot.com[/url]