Re: SQL Adaptor: Receive and Send Ports

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.

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.

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