Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to insert data into SQL Server without using SQL Adapter
- This topic has 4 replies, 1 voice, and was last updated 9 years, 1 month ago by
community-content.
-
AuthorPosts
-
-
March 3, 2009 at 1:35 PM #21817
Hi Gurus
I have a scenerio where I have to insert data into SQL Tables without using SQL Adapter, can any one help me in this regard.
Thanks
-
March 4, 2009 at 7:55 AM #21822
Hi,
create a .NET component which inserts to SQL, than call this component from an orchestration.
Laszlo
-
March 4, 2009 at 8:28 AM #21824
This component is called in Expression shape rite, so I need to debatch xml’s from a message and then insert these xml into a column of the table, my question is when debatching several xml’s from a message do I need to use one expression shape to debatch one xml or is it possible to use only one expression shape for debatching several xml’s from a msg? and after that I need to insert these xml’s into their respective columns of the table and can I do this insertion in one expression shape like inserting different xml’s into different tables.
Thanks
-
-
March 4, 2009 at 1:17 PM #21826
Can you please share more information? What kind of data do you want to insert? Will the data be available in a message being picked up by BizTalk? Do you need BizTalk for the solution?
Solutions to this could range frmo creating a dll in c# that performs the inserts and call it from a custom pipeline component or from an orchestration, to creating your own adapter.
The SQL Adapter is usually recommended though.
-
March 5, 2009 at 6:04 AM #21833
Hi Thiago
I have a msg which contains three records and I have to create xml’s or load xml for these 3 records each of one xml and then I need to insert into a SQL table column, I need to do this How do I do? According to my knowledge I have to do in expression shape so is this correct, if so how do I do it?
I need to insert data into SQL without using SQL adapter, what I am thinking is I need to write a .net component and call those methods in the expression shape, is this correct? and can I use one expression shape for inserting 3 different values into 3 different tables?
Thanks
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.