Hi Everyone

I have to read data from a SQL 6.5 server. Since SQL adapter with BizTalk
server 2004 does not work with SQL 6.5 I have written my own component to
access data. But the only way to schedule an orchestration to use SQL adapte
r
and the SQL adapter will run as polling service and will get the data from
SQL server and instantiate the orchestration. Is there a way that I can buil
d
orchestration which gets invoked automatically after a certain time. Please
help.

Thanks and Regards
Ashish Shukla

[ Post a follow-up to this message ]

Hi Ashish,

There's been a few questions on this, and not too many neat answers.

You could expose an orchestration as a web service, then create a windows
service to trigger it.

/Alan

"Ashish Shukla" wrote:

> Hi Everyone
>
> I have to read data from a SQL 6.5 server. Since SQL adapter with BizTalk
> server 2004 does not work with SQL 6.5 I have written my own component to
> access data. But the only way to schedule an orchestration to use SQL adap
ter
> and the SQL adapter will run as polling service and will get the data from
> SQL server and instantiate the orchestration. Is there a way that I can bu
ild
> orchestration which gets invoked automatically after a certain time. Pleas
e
> help.
>
> Thanks and Regards
> Ashish Shukla

[ Post a follow-up to this message ]

Thanks for the suggestion Alan. I will try it out.

Regards
Ashish Shukla



Alan Smith wrote:
[vbcol=seagreen]
> Hi Ashish,
>
> There's been a few questions on this, and not too many neat answers.
>
> You could expose an orchestration as a web service, then create a windows
> service to trigger it.
>
> /Alan
>
> "Ashish Shukla" wrote:
>
> 

[ Post a follow-up to this message ]