|
Home > Archive > BizTalk Server General > April 2005 > SQL AIC Help Please!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL AIC Help Please!
|
|
| Phil - Wales (UK) 2005-04-26, 7:47 am |
| Currently developing system where some fields have free text, formatted with
several Line Feeds (LF). All ok until I use the BizTalk SQL AIC to write to
SQL Server database; it appears to strip out any CRs & LFs. I have run some
brief tests that seem to prove this. I’ve even wrote a simple AIC that stores
free text and LFs (ASCII 10) in database ok. The XML source that uses the AIC
has preserved LF etc., and seems to make no difference if I write directly or
use a stored procedure. Anyway, does this AIC remove LFs? I would still like
to use the Biztalk SQL AIC, if possible, as it is suitable for my complex
data mapping. Any simple workarounds? Any comments, suggestions much
appreciated. Using BizTalk Server 2002 and VB6.
| |
| Phil - Wales (UK) 2005-04-26, 5:53 pm |
| Further tests show CRLFs are replaced by spaces! Why? Suggestions!
"Phil - Wales (UK)" wrote:
> Currently developing system where some fields have free text, formatted with
> several Line Feeds (LF). All ok until I use the BizTalk SQL AIC to write to
> SQL Server database; it appears to strip out any CRs & LFs. I have run some
> brief tests that seem to prove this. I’ve even wrote a simple AIC that stores
> free text and LFs (ASCII 10) in database ok. The XML source that uses the AIC
> has preserved LF etc., and seems to make no difference if I write directly or
> use a stored procedure. Anyway, does this AIC remove LFs? I would still like
> to use the Biztalk SQL AIC, if possible, as it is suitable for my complex
> data mapping. Any simple workarounds? Any comments, suggestions much
> appreciated. Using BizTalk Server 2002 and VB6.
|
|
|
|
|