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

[ Post a follow-up to this message ]

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] 

[ Post a follow-up to this message ]

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 jus
t
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 t
o
> create messages as output, though you still can have expression inside and
> call SP.
>
> -- Michael
>
> -------------------- 
> night 
>
>

[ Post a follow-up to this message ]