|
Home > Archive > BizTalk Server Orchestration > June 2006 > Stored procedure
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]
|
|
|
| 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
| |
| Dick Dijkstra 2006-06-02, 7:16 am |
| 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
| |
|
| 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:
>
| |
| amit chaudhary 2006-06-05, 7:23 am |
| 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!!!!!!!!!!!!
|
|
|
|
|