title: SQL Server table stopped reading from csv suddenly
body: <p>I have a table in a db in SQL Server that reads data from a csv file that's being uploaded to a ftp each night. The table shows data for the past 30 days, but suddenly it stopped showing entries past a certain date. </p>
  
  <p>I've checked the ftp dump and the csv file - everything here looks fine here (nothing's changed). The table itself is created using SSIS, and I've found various script for extract, load and transform. However, I'm unsure of how and where to start troubleshooting. </p>
  
  <p>I realize that this is somewhat a broad question, so I'm looking for a way or narrowing down the problem? </p>