- This topic has 4 replies, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
I have a requirement to process an excel attachment that comes via email, and then insert the data into a SQL Database. Needs to be done through BizTalk.
What would be the best way to accomplish this, in terms of architecture/steps.
I have thought of a solution but it may not be the most optimum way of doing this.
My idea is to
1) retrieve the attachment via the pop3 adapter and save the attachment to the file system.
2) Parse it using a custom pipeline which creates a xml document of all the data
3) Debatch the xml into individual messages
4) Insert the data using sql adaptor. -
Hi,
To load data into your BizTalk process from an Excel file (from step 2 above), see the discussion in the following BizTalkGurus thread:
http://www.biztalkgurus.com/forums/p/14686/28366.aspx#28366
Then use WCF SQL adapter to insert the data into SQL database.
Best,
Daniel.
-
Thank you for the guidance.
Looking at other posts as well, it seems WCF-SQL adaptor is the way to go cause of the performance
Is there any link which describes how to configure it?
-
Hi,
Here are a few blogs describing how to use WCF SQL adapter:
Also, if you have time, check out this webcast presentation of WCF SQL adapter:
http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521554268962766719
Daniel.
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.