Browsing the archives for the TABLESAMPLE tag

Write Row Count to Flat File Using SSIS: Part III

This is the third and final part to this thread on how to capture the number of rows being processed in SSIS to a flat file. In Part I we learned how not to do it and why it didn’t work. In Part II we showed how to use the ROW COUNT transformation to populate […]

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 […]

2 Comments

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 […]

0 Comments