I am trying to call a stored procedure that in turns calls an SQL Bulk Load.
Based on files created on the file system, I know it is getting called.

The stored procedure returns data as follows:
INSERT
INTO	@ReturnTable
SELECT	@Return AS ReturnValue
,		@ReturnMessage AS ReturnMessage

SELECT	*
FROM	@ReturnTable AS Results
FOR XML AUTO, ELEMENTS

I custom built by schema for the SQL rather than using the SQL Adapter.
Because of the error below, I have tried to simplify and simplify until the
error goes away - but that has not worked.

----------------------------------------------------------------------------
--------
Microsoft.XLANGs.Core.UnexpectedMessageTypeException: Received unexpected
message type '' does not match expected type
'http://Odimo.com/Amazon/SettlementBulkLoad#BulkLoadSQLResp'.

at
Microsoft.BizTalk.XLANGs.BTXEngine.BTXPortBase.VerifyTransport(Envelope env,
Int32 operationId, Context ctx)

at Microsoft.XLANGs.Core.Subscription.Receive(Segment s, Context ctx,
Envelope& env, Boolean topOnly)

at Microsoft.XLANGs.Core.PortBase.GetMessageId(Subscription subscription,
Segment currentSegment, Context cxt, Envelope& env, CachedObject location)

at Odimo.Amazon.Settlement.orSettlement.segment1(StopConditions stopOn)

at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s,
StopConditions stopCond, Exception& exp)
Microsoft.XLANGs.Core.UnexpectedMessageTypeException
Scoped@
orSettlement.orSettlement
----------------------------------------------------------------------------
--------
My SQL schema has two root elements:
BulkLoadSQLReq and BulkLoadSQLResp
Under the BulkLoadSQLResp I have simplified to the <ANY> element, so that I
could try to avoid the error totally.

In my Send Port (Request/Response) I have set
root element name to: BulkLoadSQLResp
and target namespace to: http://Odimo.com/Amazon/SettlementBulkLoad
(which matches the namespace of the schema).


Thanks a lot,
Neal Walters
http://Biztalk-Training.com - Free Biztalk Demos

[ Post a follow-up to this message ]