Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mrssawboy
Starting Member
2 Posts |
 Posted - 2008-11-24 : 13:47:39
|
| I have tables for which I will export and import data on a regular basis. I want to do this from a stored procedure and record the # of rows which were exported and imported into a statementlog table for audit. How can I obtain the rowcount/record count? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-24 : 13:53:41
|
| Use Rowcount Transformation in SSIShttp://wiki.sqlis.com/default.aspx/SQLISWiki/Row%20Count%20Transformation.html?diff=y |
 |
|
|
mrssawboy
Starting Member
2 Posts |
Posted - 2008-11-24 : 13:59:49
|
| Thank you for the quick reply. I will give it a try. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-25 : 00:21:27
|
| if you want to do this in stored proc just take @@ROWCOUNT value after insertion/updation, add them and insert this value into log table. |
|
|
|
|
|
|
SQL Server 2005 Record Counts from Import/Export