hoping someone can help me out. I have no idea what's going on with this job. It runs every week night and always comes back with the same errors.
There are about ten files that are written. We pull the data from our database then convert them to flat files and send it to a third party vendor. Our third party has reported back that all they can view on the error files are the headlines, but no info.
I ran the job manually in debug mode in ssms and there are absolutely no bugs in the package itself. the job succeeded just fine.
Some background – this job has been running with errors since july, which is around the time they set up a new school year as this job is for an educational setting.
Best Answer
If I remember correctly SSIS samples the first 1000 rows of a data set to determine the output datatype. If then row 1001+ exceeds the datatype that SSIS chose, you'll get a truncation error. You will need to update offending column to have a longer data type. Look in the advanced menu in your connection.