August 19, 2009 at 1:17 pm
I'm not sure how to fix this.
I have about 50+ text files which are very large.
These text files are generate from our main frame
(which I have control over as far as building the text files).
All the text files are created in the same format - delimited cr/lf and tab for the rows.
I've attached a screen shot of the connection manager.
Column 66 is a varchar(7) and nulls are allowed. Actually nulls are allow any where I could find a box to click on (trying anything at this point). Typically column 66 can be populated with 'REGN', 'DEFAULT' or null. There is a cr/lf at the end of the row or next to REGN, but SSIS is not see it.
Since SSIS is not seeing the cr/lf the next row is being concatinated to column 66.
Has anyone experienced this, if so how did you fix it?:cool:
August 19, 2009 at 1:22 pm
Some mainframes use something other than cr/lf for end-of-line. You might want to check what's being done on that end.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 1:25 pm
Thanks for the quick reply.
Yes, I've verified the cr/lf is truly there.
August 19, 2009 at 1:27 pm
Your screen shot is of the preview. The delimiters are on a different tab. What do you have there?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 1:30 pm
Maybe I stated the delimiter backwards.
Should be row delimiter cr/lf
and column delimiter tab.
See attachment
August 19, 2009 at 3:01 pm
The screen shot looks correct.
If that's not doing what you need, then there's something about the file that isn't matching up. Perhaps the code page?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 4:14 pm
Try importing the file in excel. this will help you determine if there is problem with file or ssis. We import lot of files generated from main frame and sometimes face such issues. usually it is the file that has problem.
August 20, 2009 at 6:40 am
I've loaded the file in excel and it looks good.
From my research it looks as if it may be trailing nulls, however I've tried filling the nulls with a value which only moves the following row to another column.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply