Integrating Integrators – BizTalk, Windows Azure, Windows Workflow, and Beyond

Re: SQL Adaptor: Receive and Send Ports

BizTalk 2004

This group is for all content related to BizTalk Server 2004. This includes a forum, samples, videos, labs, whitepapers, and tools. Most of the content here also applies to other versions of BizTalk beyond 2004.

SQL Adaptor: Receive and Send Ports

  • rated by 0 users
  • This post has 2 Replies |
  • 0 Followers
  • Hi,

    I know you guys are all BizTalk gurus out there.

    I am new to BizTalk and am using BizTalk 2004. I am trying to connect and read data from a SQL server database table and insert this this data into another SQL server database table with same fields using BizTalk 2004.

    I know how to do this by reading from an XML file and writing to a SQL server database table but from a SQL server to another SQL server does not seem to work for me.

    Do you have an example or step by step procedure to help me out. any help will be appreciated.
    Edit
  • Have you taken a look at this white paper: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp

    I think Todd has some samples available for download with the paper that might help.

    Stephen W. Thomas
    http://www.BizTalkGurus.com

  • hey caould please let me know how to do reading from XML and writing to a SQl database.

    Edit
Page 1 of 1 (3 items)