My Flat File connection manager is creating a flat file that has way too many spaces between my fields. I am exporting columns from a table which in the end should only produce a fixed length flat file of 100 bytes but there are a ton of spaces between the columns for some reason.
http://www.photopizzaz.biz/junk/4.jpg
http://www.photopizzaz.biz/junk/7.jpg
You're using fixed width and likely the default width, which is 50 characters. You might want to switch to delimited or use a smaller fixed width.|||thanks much, found it.
没有评论:
发表评论