I have not ever seen this one and wondering if anyone has. I have a scheduled SSIS job that transforms two tsv file data and sends it over to a sql table. It has been working for several months now until a few days ago. When trying to troubleshoot missing data, I opened the SSIS project and can see the data in preview of the flat file connection. When I open the connection for the oledb table, there is NO data in Preview. However when I do the exact same thing for the second tsv file that is being transferred in, it works fine. The outside agency that is providing us the files through SFTP did change the first one the other day, but I thought I made necessary changes I need to and still nothing. I even took it as far and doing a NEW SSIS job just to see and still nothing.
Has anyone seen anything like this and is there anything I should be looking for in the tsv file itself?