Output Parameter question for Execute SQL Task

• ktlady

  SSCommitted

  Points: 1509

  More actions

  July 7, 2010 at 12:24 pm

  #223053

  Hi SSIS experts,

  I have a Execute SQL Task that outputs a parameter User::RecCount. On the PostEvent of the task, I could see that the RecCount value was updated to 100 (BTW, the initialized value was -1).

  However, when I try to grab the RecCount from output Parameter in the next task, the RecCount was back to -1.

  Why didn't it keep the value as soon as it exit out the "Execute SQL Task"? How could I keep it?

  Sorry I don't know how to post images here. If you know the task, you know what I am talking about.

  Thanks in advance for any help!

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  July 7, 2010 at 4:26 pm

  #1189908

  Just to confirm, do you have only one variable User::RecCount or multiple variables with same name and different scope - one for Execute SQL Task and another for Package? If Yes then this is the reason.

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers

• ktlady

  SSCommitted

  Points: 1509

  More actions

  July 7, 2010 at 6:00 pm

  #1189932

  I just have one RecCount Variable and I had set it to be global to the package level and initialized to 0.

• ktlady

  SSCommitted

  Points: 1509

  More actions

  July 7, 2010 at 6:06 pm

  #1189936

  Oh, no, i lied.

  Just checked again, you were indeed right!

  Can't believe that I made that mistake. I thought I checked.

  Thanks!!!