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 em
pty string. I've tested this by sending the document to the file system inst
ead 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 an
d r
equired.[vbcol=seagreen]
>
>Many thanks for the suggestion
>
>"Jan Eliasen" wrote:
> 

--
Jan Eliasen, representing himself and not the company he works for.

[ Post a follow-up to this message ]