BizTalk Server - SQL Adapter - Lesson Learned

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > December 2004 > SQL Adapter - Lesson Learned





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author SQL Adapter - Lesson Learned
Ali

2004-12-30, 2:46 am

I spent a whole day on a very stupid thing. I hope this helps someone out
someday.

Am using the SQL Adapter to execute a SQL Server stored procedure.
Responseroot accepts input parameters through a tranformation, Requestroot
brings results back (output fields are promoted in the schema to be
accessible in an orchestration). Orchestration has variables which get
populated once the stored procedure is called. Was trying to debug the
orchestration by checking the values of these variables (output fields of
stored procedure) and they kept returning null in the orchestration debugger.
Spent a whole day just trying to do this in many different ways.

Figured out that not until you ACTUALLY "USE" VARIABLES will their values
get exposed. Frustrating.
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com