469,322 Members | 1,648 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,322 developers. It's quick & easy.

Logging Rows Processed by various stored procedures within a DTS package

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...
Apr 4 '07 #1
5 1750
iburyak
1,017 Expert 512MB
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.
Apr 4 '07 #2
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!
Apr 5 '07 #3
iburyak
1,017 Expert 512MB
[PHP] Select @@Rowcount[/PHP]

Returns number of rows affected.
Apr 5 '07 #4
iburyak
1,017 Expert 512MB
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.
Apr 5 '07 #5
[PHP] Select @@Rowcount[/PHP]

Returns number of rows affected.


Thank You very much...your help is much appreciated!!
Apr 20 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Anthony Robinson | last post: by
4 posts views Thread by lfhenry | last post: by
5 posts views Thread by william.david.anderson | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.