BizTalk Server General - Using Business Rules on response from SQL Server Stored Procedure

Author

Using Business Rules on response from SQL Server Stored Procedure

TimG

2004-10-27, 2:47 am

Hi

Within an orchestration I call the SQL Adapter to resturn a result set from
a stored procedure. However I wish to interrogate the result set via the
business rules engine.

When I add a rule to check the attribute
SQLService/MyResponseRoot/app/lvr_linked the rule does fire. However if I map
the reponse node to a new message (map to new schema) and change the rule to
interrogate the new attribute the rule fires, I sthis the best way to do it
or is there a way of using the response node from SQLService.xsd

Thanks

Tim