|
Home > Archive > BizTalk Server Orchestration > June 2006 > Executing stored procedures in Biztalk 2006
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 |
Executing stored procedures in Biztalk 2006
|
|
| Lee Manifold 2006-06-05, 7:23 am |
| Morning Chaps,
I'm using Biztalk2006 with SQL2005 and I am trying to truncate a table
before I run the rest of the orchestration (Which inserts into the
table(s)). Does any kind soul know how to execute a strored proc in the
orchestration? I have tried using it as a message type with a
ConstructMessage and a messageAssign. I get the 'Messages Constructed'
error which I sort of expect. For something so simple it's proving a night
mare.
Thanks in advance
Lee
| |
| Michael Elizarov [MSFT] 2006-06-07, 1:19 am |
| Lee,
did you try expression? Message construction and assignment are expected to
create messages as output, though you still can have expression inside and
call SP.
-- Michael
--------------------[vbcol=seagreen]
night[vbcol=seagreen]
| |
| fullflavedave 2006-06-07, 7:18 pm |
| Perhaps I'm being totally naive in this, but I call stored procedures in my
orchestrations using a callout to sql server: rt. click project --> add
generated items --> add adapter metadata --> choose the SQL adapter and
follow the wizard. Then add a port, choose "Use Existing Port type", and
select the port type generated by the adapter. Perhaps a lot of work to just
call a stored procedure, but I think it would work.
Dave
"Michael Elizarov [MSFT]" wrote:
> Lee,
> did you try expression? Message construction and assignment are expected to
> create messages as output, though you still can have expression inside and
> call SP.
>
> -- Michael
>
> --------------------
> night
>
>
|
|
|
|
|