Logging Rows Processed by various stored procedures within a DTS package

[gatorone]

I have a situation where we are executing multiple stored procedures within a DTS package...Is it possible to have the rows processed for each stored procedure sent or stored to a log file?

Any help would be much appreciated...

[iburyak]

Write code in each procedure to do that for you.

Or you can write a trigger over each table to log your changes.

Good Luck.

[gatorone]

Write code in each procedure to do that for you.

Or you can write a trigger over each table to log your changes.

Good Luck.

Thanks for the quick reply...

In this case I don't believe triggers is my answer, and I probably needed to provide more information in my original question.

My stored procedures are really nothing more than simple Insert and Update SQL statements where I am inserting rows from one table into another table. When I run the stored procedures in Query analyzer, I get the "rows processed" message back to the screen. I was wondering if there was a way to capture this same type of data when running the stored procedure within a DTS package. You referenced the possibility of inserting code to capture this information...I've spent some time trying to find references on how to do this...is there a quit simple tidbit of code that you could point me to, that would be much appreciated...

Thanks for your help!

[iburyak]

[PHP] Select @@Rowcount[/PHP]

Returns number of rows affected.

[iburyak]

This line should be used as a next line after insert\update.
No cede between your query and @@Rowcount
Like this:


[PHP] Insert into table1 values (....... )
Select @@Rowcount
[/PHP]

Irina.

[gatorone]

[PHP] Select @@Rowcount[/PHP]

Returns number of rows affected.

Thank You very much...your help is much appreciated!!