You need to define the delimiter of 0x0D 0x0A as either post fix or infix
delimited which ever it is...
Infix:
XS0000,CALL_SCHEDULE,C,2049-03-21 00:00:00.000,100.0000,2017-06-21
00:00:00.000,,,,,,,,350000000.00,<CRLF>
XS0001,CALL_SCHEDULE,C,2049-06-21 00:00:00.000,100.0000,2017-06-21
00:00:00.000,,,,,,,,350000000.00,
Post fix:
XS0000,CALL_SCHEDULE,C,2049-03-21 00:00:00.000,100.0000,2017-06-21
00:00:00.000,,,,,,,,350000000.00,<CRLF>
XS0001,CALL_SCHEDULE,C,2049-06-21 00:00:00.000,100.0000,2017-06-21
00:00:00.000,,,,,,,,350000000.00,<CRLF>
Eric
http://blog.biztalk-info.com
"shadowplayer" <shadowplayer@[EMAIL PROTECTED]
> wrote in message
news:%23gjqDMAtHHA.484@[EMAIL PROTECTED]
> Hi,
>
> I have a simple csv flat file debatching schema which does not work when
> the incoming csv ends with a CRLF
>
> i.e.
>
> XS0000,CALL_SCHEDULE,C,2049-03-21 00:00:00.000,100.0000,2017-06-21
> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
> XS0001,CALL_SCHEDULE,C,2049-06-21 00:00:00.000,100.0000,2017-06-21
> 00:00:00.000,,,,,,,,350000000.00,
>
> works but
>
> XS0000,CALL_SCHEDULE,C,2049-03-21 00:00:00.000,100.0000,2017-06-21
> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
> XS0001,CALL_SCHEDULE,C,2049-06-21 00:00:00.000,100.0000,2017-06-21
> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
>
> does not.
>
> The error re****ted is:
>
> "Unable to match the data in the input stream."
>
> Strangely though this does work when I set
> RecoverableInterchangeProcessing to true...
>
> I'm sure there must be a simple answer to this but it has eluded me for
> two days now :-)
>
> My schema is attached.
>
> Many thanks
>
>
|
