variable problem

• gravitysucks

  Ten Centuries

  Points: 1122

  More actions

  June 20, 2012 at 4:51 pm

  #260197

  I have been trying this all day but don’t seem to get to work. What I am trying to do is to capture the number of rows deleted/inserted/updated by a stored procedure. I have two proc to do these. I captured @@rowcount values to an integer output parameter in store procedure. I then call this sp from execute sql task and map the parameter to a package variable as output like this EXEC ? = dbo. procname ? OUTPUT, this is right? or is it exec dbo.procname ?output.What difference is between return code and output parameter? After that I need to insert these variable values and current timestamp. How in the world do I insert SSIS variable values into a table? Any suggestions will be greatly appreciated.

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  June 22, 2012 at 12:57 am

  #1504351

  Please do not crosspost. It fragments replies and wastes peoples time.

  Original thread with replies can be found here:

  http://www.sqlservercentral.com/Forums/Topic1319065-391-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP