|
| Hi,
I have an orchestration while trying to execute a transform
in the ConsrtuctMessage.
The Event log shows WARNING:
The adapter "SQL" raised an error message. Details
"HRESULT=3D"0x80040e14" Description=3D"The request for procedure 'AA'
failed because 'AA' is a table object."
=EF=BB=BF<?xml version=3D"1.0" encoding=3D"utf-16" ?><ResponseData
xmlns=3D"http://SQLDosDataReceiveProject"><?MSSQLError
HResult=3D"0x80040e14" Source=3D"Microsoft OLE DB Provider for SQL Server"
Description=3D"The request for procedure 'AA' failed because 'AA' is a
table object."?></ResponseData>".
Input data is
<ns0:Data xmlns:ns0=3D"http://BizTalkProject.SQLData">
<AA>
<BB>xxx</BB>
<CC>xxx</CC>
<DD>xxx</DD>
</AA>
</ns0:Data>
Send Map name as Map1
Data
sync
Data after
AA AA
BB------------------------------ BB
CC----------------------------- CC
DD----------------------------- DD
ReceivePort :FILE
ReceivePipeline is Pass XMLReceive
SendPort:SQL
send Pipeline is Pass XMLTramsit
send Map : Map1
Note: It is inserting in the SQL DataBase but i am getting above
Warning every time i insert a record.
Please Help me.
thanks,
wask
|
|