<div>
A word of caution.<br />
@@ROWCOUNT would be reset for every instance of insert. So, you might have to save it for logging before/after commit.
</div>


A word of caution.
@@ROWCOUNT would be reset for every instance of insert. So, you might have to save it for logging before/after commit.

<div>
sameer2010<br />
<br />
I am not sure what you mean. 
</div>


<div>
@@ROWCOUNT value changes after every ddl statement. for that reason you should use it immediatly after you run your query or store that value for later use.. this what sameer2010 mean.
</div>


@@ROWCOUNT value changes after every ddl statement. for that reason you should use it immediatly after you run your query or store that value for later use.. this what sameer2010 mean.

<div>
Create a stored procedure with an output parameter using the @@RowCount function and get it from a SQLtask inside SSIS.<br />
FOr SQL task details check this link:<br />
<a href="http://www.sqlis.com/post/The-Execute-SQL-Task.aspx" rel="ugc">http://www.sqlis.com/post/The-Execute-SQL-Task.aspx</a><br />
helped?<br />
Regards,<br />
Pedro
</div>


Create a stored procedure with an output parameter using the @@RowCount function and get it from a SQLtask inside SSIS.
FOr SQL task details check this link:
http://www.sqlis.com/post/The-Execute-SQL-Task.aspx [http://www.sqlis.com/post/The-Execute-SQL-Task.aspx]
helped?
Regards,
Pedro

<div>
<div class="content wysiwyg-content">
I am trying to log counts of records inserted via a sql task. Can anyone tell me how best to do this. Right now I log counts in the data flow by using VB code in a Scrip Component, but I need to be able to capture counts in the SQL Task.
</div>
</div>


I am trying to log counts of records inserted via a sql task. Can anyone tell me how best to do this. Right now I log counts in the data flow by using VB code in a Scrip Component, but I need to be able to capture counts in the SQL Task.

Record Count In Execute SQL Task

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.