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 7 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply