|
Home > Archive > BizTalk Server General > October 2005 > SQL Adapter Problem
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 Problem
|
|
| insanekid 2005-10-02, 7:49 am |
| Greetings,
I am currently new in Biztalk. I'm trying to use SQL Adpater of
Biztalk. I want to access a stored procedure of Biztalk however
there are input & output parameters on the stored procedure. I
want to set the input parameters dynamically. How could I do that?
Thanks,
insanekid 
| |
| Danny Buysse 2005-10-03, 7:48 am |
| Have a look at the SQL Adpater samples
(http://blogs.msdn.com/scottwoo/arch...3/11/88387.aspx).
Probably this will help you.
Danny.
"insanekid" wrote:
> Greetings,
>
> I am currently new in Biztalk. I'm trying to use SQL Adpater of
> Biztalk. I want to access a stored procedure of Biztalk however
> there are input & output parameters on the stored procedure. I
> want to set the input parameters dynamically. How could I do that?
>
>
> Thanks,
> insanekid
>
>
| |
| insanekid 2005-10-04, 7:57 am |
| Hi Danny,
I already tried those samples already but still I can't find a
solution on the parameters especially on stored procedures that
contains the output parameters.
For example:
Supposedly I had this stored proc.
CREATE PROCEDURE SP_SQLSendTable_Output
@col_varchar varchar(30) output
AS
SELECT @col_varchar=column_varchar
FROM (
SELECT TOP 1 col_varchar AS column_varchar
FROM SQLSendTable
) SQLSendTable
FOR xml auto, xmldata
GO
@col_varchar returns the column_varchar.
The problem in SQL Adapter is that the output parameter @col_varchar
is not shown when you use "Add Generated Schema" wizard so I wasn't
able to generate the schema for SQL adapter because I can't continue
the wizard due to the errors it keeps giving me when i tried click on
next.
How should I do this? If there are anything that is not clear, just
let me know.
Thanks
|
|
|
|
|