I have a mapping that translates a XML to a XML that can
be used by the SQL Adapter for Biztalk. In that XML it
can happen that some fields are empty. The result of the
mapping is then for example:

<param01 name="name" value=""/>

In the storedprocedure there will be a variable:
@name=""
SQL can not deal with this. How can I solve this, because
I want a Null for that variable. Is the only solution to
deal with this in the storedprocedure it self?

Thanks

[ Post a follow-up to this message ]

On Thu, 4 Mar 2004 00:17:29 -0800, "Norbert"
<anonymous@discussions.microsoft.com> wrote:

Phil has suggested a solution. Other than his solution, you could try
to just look at the input element/attribute and if it doe snot exist,
then write a "Null" to the destination, else write the input to the
destination.


>I have a mapping that translates a XML to a XML that can
>be used by the SQL Adapter for Biztalk. In that XML it
>can happen that some fields are empty. The result of the
>mapping is then for example:
>
><param01 name="name" value=""/>
>
>In the storedprocedure there will be a variable:
>@name=""
>SQL can not deal with this. How can I solve this, because
>I want a Null for that variable. Is the only solution to
>deal with this in the storedprocedure it self?
>
>Thanks

--
Jan Eliasen, representing himself and not the company he works for.
MCP in Microsoft BizTalk Server

[ Post a follow-up to this message ]