Page 1 of 1
did not consume entire input, at offset: 159
Posted: Tue Jul 27, 2010 8:09 am
by krisna
Iam reading data from sequential file. Data in sequential file is a comma delimited, final delimiter is end, double quoted. Issue here is one of the field contains value like this "1905 E COUNTY RD "D"". While reading data these records are getting dropped. Please help me out this problem its an urgent requirement.
Thanks in advance
Posted: Tue Jul 27, 2010 8:14 am
by anbu
Either pre process the file and remove the quotes
Or
Remove double quote option from sequential stage and remove unwanted quotes in transformer
Posted: Tue Jul 27, 2010 6:23 pm
by ray.wurlod
If the requirement is urgent, as you claim, sign up with your official support provider for priority service, and learn just how much "urgent" costs.
DSXchange is an all-volunteer site, whose members post as and when they can. Note also that they are under no compulsion to do so.
Posted: Tue Jul 27, 2010 8:25 pm
by nvdlrao
Change the Data type to NVARCHAR followed by Unicode. It will work.
[* Above line corrected from unique to Unicode - Andy *]
Posted: Wed Jul 28, 2010 2:58 am
by ArndW
nvdlrao wrote:Change the Data type to NVARCHAR followed by unique. It will work.
No, it won't work using those suggestions. NVarChar and VarChar aren't relevant when it comes to sequential file quoting. And what "unique" has to do with this query is beyond me. Perhaps I have missed something and you could explain your suggestion in detail.
Posted: Wed Jul 28, 2010 12:42 pm
by nvdlrao
Its my bad, I mean unicode not unique.