Please ignore this .. This is just one extra step that I had to do in the SSIS package to make sure that I get an accurate count of how many records are there in the file.

This was a very large file having 6 million records. Have to count to make sure we accounted for all the entries.

So we can put this code inside a script object and then pass the value of [count] to a SSIS variable


string TheFile = "S:\\MIS\\Provider NPI file\\Processed\\npidata_20050523-20161009.csv";int count = 0;using (System.IO.StreamReader sr = new System.IO.StreamReader(TheFile))
{  while (sr.ReadLine() != null)   count++;}