June 20, 2012 at 4:51 pm
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.
June 22, 2012 at 12:57 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply