Rowcount Task

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  April 13, 2012 at 6:16 am

  #254817

  I found an excellent example of logging in SSIS. Unfortunately I could not find the correct version of AdventureWorks (2005?) which be nice to have.

  http://www.mssqltips.com/sqlservertip/1417/custom-logging-in-sql-server-integration-services-ssis/#comments

  The package uses the RowCount Task. I noticed the Variable that it uses to capture the RowCount and the Input and Output parameters but I'm baffled on how it works and how to configure it.

  Prior to SSIS I wrote a lot of DTS and I used a EXEC SQL Task with output parameter going to global variables.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  April 13, 2012 at 11:59 am

  #1473398

  SQL Server 2005 SP2a Product Samples

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato