BizTalk Server General - Re: Executing Stored Procedure

Author

Re: Executing Stored Procedure

McGeeky

2005-06-24, 2:47 am

You can set a stored procedure to be run at regular intervals using a SQL
receive port. The result set returned from the stored procedure is converted
in to a message.

--
McGeeky
http://mcgeeky.blogspot.com

"Eric" <ericstott.dontspamme@hotmail.com> wrote in message
news:%23Y8AjLEeFHA.2732@TK2MSFTNGP14.phx.gbl...
>I need a Stored Procedure at various intervals during the day, it then
>needs to be fed to a map. Is there a way to call this stored procedure in
>an orchestration, or do you set up when this stored procedure runs in SQL
>server and then get a response fed directly into BTS?
>
> Thanks for your assistance,
> Eric
>