SQL Adaptor: Receive and Send Ports

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Adaptor: Receive and Send Ports

Viewing 1 reply thread
  • Author
    Posts
    • November 17, 2005 at 9:03 PM #12352
      community-content

        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.

      • November 19, 2005 at 6:33 AM #12353
        community-content

          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.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.