Browsing the archives for the row count tag

Write Row Count To Flat File Using SSIS: Part II

In yesterday’s post we pulled a Thomas Edison and showed one of 10,000 ways how not to write the number of records being processed using the ROW COUNT transformation. We thought the process was straight forward, but it didn’t work.  Our approach was: 1.  Create a query that processed some records. 2.  Send the result […]


Writing Row Count to Flat File in SSIS: Part I

Yesterday I had a simple enough task at hand.  An existing EXTRACT that loads a result set to a DATA file needed to have a corresponding COUNT flat file that contained the number of rows in the extract’s data file.  Not being the most savvy at SSIS I did what anyone else would do get […]


Table Row Counts

The easiest way to count the number of rows in a table, from the user perspective, is to use the simple COUNT(*) operator.  A more efficient method to count the number of records in a table is to use SQL Server’s system tables. Let’s start out with the naive approach and see how it performs. […]