title: SSIS 2008 Row Count Transformation - Row count return 0
body: <p>This should be rather simple but I don't know why I get Row Count as Zero when I use ROW COUNT transformation in Data Flow Task. I have created a variable(NoOfRecords) with Package scope.</p>
  
  <p>Variable name set to variable NoOfRecords in Row Count Transformation. <img src="https://i.stack.imgur.com/a9wgb.png" alt="Image1"></p>
  
  <p>Used a Derived column to assign the row count.<img src="https://i.stack.imgur.com/A8xQq.png" alt="Image2"></p>
  
  <p>The package runs successfully and shows record count 265<img src="https://i.stack.imgur.com/Bu2NE.png" alt="Image3"></p>
  
  <p>But the Derived column shows record count as 0 instead of 265 rows. <img src="https://i.stack.imgur.com/zRUNx.png" alt="enter image description here"></p>