SSIS Execute SQL Task calls a stored procedure. How to get count of records returned by SP

Question

My SSIS has Execute SQL Tasks which just calls a stored procedure. How to get count of records returned by the stored procedure?

Possible duplicate of [Count # of Rows in Stored Procedure Result, then Insert result into table](http://stackoverflow.com/questions/31973909/count-of-rows-in-stored-procedure-result-then-insert-result-into-table) — S3S, Sep 08 '16 at 21:07

score 0 · Accepted Answer · answered Sep 09 '16 at 00:42

0

In your stored procedure, you can include a SELECT statement to return the row count.

CREATE proc test_proc as
begin
    ....
    select rowcnt= 230
end

And as per the Execute SQL Task setup, I captured and attached 2 images here below.

answered Sep 09 '16 at 00:42

Dance-Henry

You also have to add a parameter for the output. – AnandMaharana Sep 13 '16 at 21:13

1 Answers1