I have a situation were I need to export a very wide AS400 table to a flat file. What I have done is created a dynamic SSIS process that allows reuse of objects. So that I can loop through the database grab each table and export the data out to individual flat files. But for some reason on a particular table that has over 80 columns I run into a problem where my process looks like it's writing to the flat file but no data or very little rows get written to the flat file. If I reduce the columns then the process works fine. Any ideas? I'm new to SSIS so I'm a bit lost on this one.