Insert database entry from biztalk server

Hi,

We can use SQL adapter to insert table entries from BizTalk.

Steps:

1.Make the database table ready.(Or create a new table)
2.Create a new BizTalk project, Add--> Add Generated Items.
3.Select Add adapter metadata.
4.In the Add adapter wizard, select adapter (SQL), SQL Server and database name.
No need to give port name here.
5 Create the connection string using SQL transport schema generation wizard and click next.
6.Give target Namespace (should you this same in the XML). Then select port type as 'Send Port', then provide request and response root element name.Click next.
7.Here we can select if we need to just insert entries to tables or use storedprocedures. Select Updategram and click next for inserting.
8. Select the table and required columns. Click next and we're done.
9.One orchestration and schema will be generated for this. Just finish the orchestration connections and deploy the project. Create receive(use File adapter) and send ports(use SQL adapter) in the application.
10. Drop the xml which has the data to be inserted into the table in the receive location. Check the table, it will be updated with the entries.

Regards,
Haris