Receive data from SQL Server

Hi Mr xman71,

Thanks for the suggestion…

Please let me explain more detail about the problem that i must to solve….

Actually, i have a job to do like this: (based on the company story where my project must i do)
1) That company has many information system (dekstop application based C# .net), there are : BAK, MISSION, SIKEU, SIATMA

2) Some of the information system using web service to connect with it’s database.
   So, MISSION have it’s web service to call it’s database, and so do the BAK
   Whereas, the SIATMA and SIKEU doesn’t use web service to connect with it’s database but with the usual function.
   (function that will connect directly to database)

3) But, if there are information system need data from another information system,
   example: BAK need data from MISSION the right now mechanism that company use is:
    a) If the web service that the BAK need doesn’t exist already, then MISSION will provide that web      service.
           But, if the MISSION already has the web service that BAK needs, then the BAK just use it

    b) The BAK will add web reference to that MISSION web service provide (step a)

    c) Then BAK use the function at that web service (step b) for the BAK’s dekstop application

4) It means, if one information system need data from another information system,
   the right now mechanism is:
   a) If there is no the web service that another information system need, the information system will provide it,   but, it’s already exist, the another system just using it
   b) And it’s means the information system using directly that web service with add web reference to the another system

5) The problem that we need to solve with the BizTalk is:
       a) we want to implement SOA(Service Oriented Architecture)
       b) we want to integrate the many information system we had with BizTalk
       c) we want BizTak as a broker of the many web service, so…
           example : if there are an application dekstop A need data from applcation dekstop B,
           the A application will find it in the BizTalk and BizTalk will find the correct web service
           and BizTalk will connect both application (A and B)
      d) we want to remove the point to point mechanism (by using directly each web service from          another information system will make point to point, isn’t??),
      SO, we want to implement the ESB (Enterprise Service Bus) Architecture,
      so the information system we had will not connect one to one point. (like what the right now     mechanism use by this company)

Can u give me any solution?

We use (still) BizTalk Server 2006 R2, and Visual Studio 2005 to build the application dekstop.

I am really new in BizTalk and hoping can be an MCTS for BizTalk Server like u Sir…. ^^

Great thanks,

Nengsih Fitria