1 out of 10,000? Really? - SSIS Flat File Destination Issue
Really, I have created this solution in SSIS, run nearly 10,000 files through this one package and 1 comes out with very unexplainable results. So I have a package that calls a merge statement to detect changes in the source system. Upon changes it retrieves data, based on a parameter (db key field), through an OLEDB Source and funnels that data set into a flat file destination. Sound easy and fine, until the red-headed step child... I have this one file whose row count from SSMS T-SQL query returns 2959 rows of data. The OLE DB Source task object in SSIS shows in the designer at run-time that 2959 rows of data are being mapped to the flat file destination, yet - YET for just this 1 file, the flat file comes out with 40 extra rows of data AND the data on row 2959 - 2960 are out of sync with their proper column assignments. the package successfully completes, but when this file is consumed by another package it fails due to the column mismatch and thus truncation issues. So my obvious question - how in the world is extra data getting written to the flat file for only this file? Data? - I have looked. Duplicate rows? - no - put file in excel and did compare and lookups on data in the 40 extra rows - all unique. Please help shed some light on this one. Thanks, TWBEveryone wants to develop in production, but no one wants development to be production!
January 16th, 2011 8:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics