This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Wed, Aug 29 2007
Filed under:
Filed under: sql server, ssis, error, jobs, scheduled, error log, file, truncated, destination, source