| Jan Eliasen 2004-03-18, 2:00 pm |
| 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
|