Hi,

When I tried to use datagram to insert data in the DB with SQL adapter
for BizTalk 2004, the integer/bit column is set as NULL when 1 is passed in.

For bit field, if 0 is passed in, the value is set as expected.

for integer field, if 2 and above is passed in, the value is set as
expected.



Please advise

if there is patch out there for this issue. Or if I missed anything when
setup my system.

Best regards



ming



Here is how to repro it:

Please refer to the example published at


http://msdn.microsoft.com/library/d...768ff245df1.asp



Once you install the sample code,  start the orchestration
BizTalkAdapterForSQLServer.Samples.SQL_Adapter_Updategram

1)  copy the test xml in

C:\BizTalk Adapter for SQL
Server\SQL_Adapter_Updategram\TestFiles to

C:\BizTalk Adapter for SQL  Server\SQL_Adapter_Updategram\FilePickup




Use the sql analyzer to check for the new item just inserted into the
northwind db, you should be able to see that the viaship filed is NULL



2) Change the ShipMethod element from 1 to 2 in the same test xml as
above in the dir

C:\BizTalk Adapter for SQL Server\SQL_Adapter_Updategram\TestFiles



Then copy this file to the

C:\BizTalk Adapter for SQL  Server\SQL_Adapter_Updategram\FilePickup


Check the viaship column of the new record, this column is now 2 as
expected.

[ Post a follow-up to this message ]