Problem exporting wide table to flat file using SSIS

Last Post 16 Jul 2007 02:05 PM by prospec. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
prospec
New Member
New Member

--
16 Jul 2007 02:05 PM
Hi All,
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.
You are not authorized to post a reply.

Acceptable Use Policy