BizTalk - Biztalk Sql adapter response issue

Asked By praveen kumar
02-Sep-08 08:15 AM

Hi All, I am trying to do some inserts in the database using Biztalk. I have written a stored procedure to handle that.

Ex: Create proc proc_SetTable as

   @blah varchar

   @blahblah int

   begin

insert into <table name> values(@blah,@blahblah)

end

When I generated the meta data for this stored procedure using the "Add generated items" wizard, I was able to see Request and Response nodes. I am able to see the node with the name "Success" under Response node. This is cool. However, I am not able to catch this value inside the orchestration. I am trying to map the response schema with another schema for further process. I am expecting the response message as <Success>0</Success>. Correct me If I am wrong. This is not happening. Any help will be appreciated.

 

  Frieza replied to praveen kumar
13-Jan-11 02:26 AM
Hi, Im facing the very issue that you have posted on the top, did u get a solution?? Please let me know...
  Devipriya replied to Frieza
10-Mar-11 12:03 AM
Have u got resolution i am even facing the same issue..
  Frieza replied to praveen kumar
10-Mar-11 03:00 PM
Yea i managed to solve it..... Its just that you have to provide the output variable/variables in the Stored procedures and you would acquire the corresponding elements as a response schema for your Biztalk application.

From there you can take the response as input and transform it to your desired format.
Create New Account
help
Error message from SQL adapter Windows Server I have a two-way send-receive SQL BizTalk port (BizTalk 2006). This port executes a stored procedure (SQL Server 2005). This stored procedure returns the content of a column of type 'text'. Sending a request to the sql port triggers the following error from BizTalk: A message sent to adapter "SQL" on send port "RequestToSQLPort" with URI "SQL: / / localhost / MyDB suspended. Error details: HRESULT = "0x 7a" Description = "No error description provided" After having edited the stored procedure so that the text column is converted to a local varchar(8000) variable and
Biztalk Stored Procedure problems with NULL value Hi All, In my Biztalk(2004) Orchestration, I use a stored procedure to update some tables in a database hosted by SQL Server 2003. The input of
Calling Stored procedure without parameters in BizTalk using SQL Adapter Hi I know how to use a SQL adapter calling a stored procedure with parameters from Orchestration, but how to call stored procedure without parameters when I generate metadata for the stored procedure I m just gettin the request root node so my question is do I
xml DATA FROM ORCHESTRATION to stored procedure xml parameter Windows Server i want to pass xml DATA FROM ORCHESTRATION to stored procedure xml parameter. I want to copy xml tree from source message to Stored procedure xml parameter. My problem is that mass copy cannot be assigned to a attribute field While generated scheama wizard makes parameters of stored procedure as an attribute. So how can i copy the xml into a generated schema xml
Calling parameterized SQL Stored Procedure through Orchestration Windows Server I want to call stored procedure with simple SELECT query [in loop] from orchestration which takes an input parameter [say customerCode am not aware of the way wherein I can pass the variable parameter to my stored procedure. I call the stored procedure in loop [say 5 times] and each time I call the SP I need to