I had an SSIS Package that took data from a flat file and moved it into a SQL Server table. It was working OK, but I had to add two new fields to the data. I added the fields to the data output program on the computer that generates the flat file, but had forgotten to add the fields to the heading, so the last field got populated with three fields worth of data. I was using comma delineated fields, with the last field being delineated by <CR>-<LF>, so my last field had data similar to "TRUE, EA, I". So, I went back and added the two new fields to the header and to the database table and deleted and re-created my SSIS package.
In my package, in the Flat File Source, if I edit it and click the Preview button, everything looks OK, and the new data is in the new columns. But, if I edit the OLE DB Destination and Preview it, the new fields are still back in my old last column, and the new columns are NULLs! I've tried deleting and recreating all the components of the package, but can't find what I'm doing wrong. Can anyone point me in the right direction???