|
| 1. In stored procedure params use (for example) @name
varchar(30)=NULL, ....
2. In BizTalk Mapper use a Logical Existence functoid to
connect to the record of the output specification e.g
param4 (not name or value).
If Input field exists (in data instance)will parse
otherwise will ignore and SQL server will insert a NULL.
Hope this helps (it did for me).
Philr Wales UK.
>-----Original Message-----
>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
>.
>
|
|