BizTalk Server Applications Integration - Biztalk Stored Procedure problems with NULL values

Author

Biztalk Stored Procedure problems with NULL values

mtlili

2004-09-21, 6:50 am

Hi All,

In my Biztalk(2004) Orchestration, I use a stored procedure to update some tables in a database hosted by SQL Server 2003.
The input of the orchestration is an xml file described by a XML schema, then the values written in the XML instance are mapped to the schema describing the tables in the databases.
For some reasons, I need to pass null(string, int, date) values in the input XML instance, so that the updated tables will contain NULL values.
So far, I did not figure out how to achieve that.
Anyone faced this problem in the past?
Thanks for helping

Marouane