|
| 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.
|
|