| Jan Eliasen 2004-07-16, 8:03 am |
| Hi
Perhaps you could let SQL Server hve a default value Ø(the empty
string) for that column? Then your BizTalk map can omit the
corresponding elemente from the output if the input-string was empty?
Jan Eliasen
On Wed, 14 Jul 2004 02:03:04 -0700, "James Lange"
<JamesLange@discussions.microsoft.com> wrote:
>Hi
>
>It seems that the column always exisits, even when the field contains an empty string. I've tested this by sending the document to the file system instead of the AIC.
>
>The main issue that I need to resolve is that if the field contains an empty string, that is what must be inserted. I've also ensured that the data type in the schema is declared as a string type and tested with the field an marked at both optional and r
equired.[vbcol=seagreen]
>
>Many thanks for the suggestion
>
>"Jan Eliasen" wrote:
>
--
Jan Eliasen, representing himself and not the company he works for.
|