I am trying to insert a flat file to sql server 2008. I used wcf-sql adapter and flat file schema then mapped flat file schema to sql insert shema. Then i send the insert schema to sql port. But i get that error:
Error details: Microsoft.ServiceModel.Channels.Common.UnsupportedOperationException: The action "<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Operation Name="Insert" Action="TableOp/Insert/dbo/info" />
</BtsActionMapping>" was not understood.
I tried to change sql ports operation name to Insert in visual studio. But it didnt work. Please help?
this post may help you
http://blogs.msdn.com/biztalk_adapter_development/archive/2008/01/08/why-does-the-adapter-say-action-is-not-understood-even-though-i-am-using-the-binding-file-generated-by-the-consume-adapter-service-wizard.aspx
- Marked as answer by zelish Friday, October 02, 2009 11:35 AM
zelish, what is the difference between the two action, the one which makes it work and the other?
because in your two posts you are using the same action
"TableOp/Insert/dbo/info"
Regards,
Stefan
http://www.itsconsulting.fr
I got the same issue when call stored procedure "GetOrders". so I write "Procedure/dbo/GetOrders" instead
<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Operation Name="GetOrders" Action="Procedure/dbo/GetOrders" />
</BtsActionMapping>
That work fine!
try Action="TypedProcedure/dbo/GetOrders"I got the same issue when call stored procedure "GetOrders". so I write "Procedure/dbo/GetOrders" instead
<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Operation Name="GetOrders" Action="Procedure/dbo/GetOrders" />
</BtsActionMapping>That work fine!