hi everybody,
i am using the SQL Adapter for the first time (actually for my first production BizTalk project)…
now the problem is that i have a complete orchestration built and running…now i need to update it to use the SQL Adapter in order to update a temp table in SQL Server. What i need is a way to pass in an RqUID parameter (which is an element in my message) to a stored procedure that will update my temp table. Now please note that the temp table does not correspond to a particular schema inside my project…I only want to update it for future reporting reasons…
how can i do the above, knowing that every article i read about SQL adapter required generating a schema adapter metadata and go from there. However as i said in my case i do not want to create any new metadata schemas. i simply want to retreive a RqUID parameter from a message, and then use it to update a reporting temp table.
can this be done?
thanks for your help…