I have created a package in SQL that brings in data from a flat file to SQL. In the data pump I have created an exception path to log all of the data that does not come through because of bad data such as incorrect data types etc. When I run the package and there are rows that are kicked out because of bad data they successfully are logged in the excpetion file and another text file is created to show whichs rows were rejected. The text files are pointed to a UNC path not to my local computer. My problem is when I set this package up as a job, the log file shows that there are no errors and I am obviously not getting the text file that shows the rejected rows. I am positive it is not bringing in all of the data, can you please help? Thank you.