What is the easiest way to run a storedprocedure.
the only thing the stored procedure should do is to truncate the table it is
inserting data into.
It should just run that procedure. stp_truncate.

mm

[ Post a follow-up to this message ]

mm,

Open query analyzer (isqlw.exe) and type exec <sp name>.

Dick Dijkstra


mm wrote:
> What is the easiest way to run a storedprocedure.
> the only thing the stored procedure should do is to truncate the table it 
is
> inserting data into.
> It should just run that procedure. stp_truncate.
>
> mm

[ Post a follow-up to this message ]

thanks for answer but, i was looking for the simplest way inside an
orchestration, i dont need to receive or send any parameters.
"Dick Dijkstra" <dickdijkstra@hotmail.com> wrote in message
news:1149236463.294577.225420@f6g2000cwb.googlegroups.com...
> mm,
>
> Open query analyzer (isqlw.exe) and type exec <sp name>.
>
> Dick Dijkstra
>
>
> mm wrote: 
>

[ Post a follow-up to this message ]

Hi MM,

you can execute sp by help of sql adapter in orchestration.
do not need to do much, there is wizard available which can
be used to gererate schema and orestration.
Add a generate item in your biztalk project, a wizard will be
open,you just need to follow this wizard. it will create schema and
orgestration in project. that wizard will also create logical port for
sql adapter.

artical is also avilable on microsoft site.
go on microsoft site and search for "working with sql adapter in
biztalk server".
i supposed,it will help you veru much.

by!!!!!!!!!!!!

[ Post a follow-up to this message ]