Resources for IT Professionals >
Forums Home
>
BizTalk Server Forums
>
BizTalk Server Adapters and Adapter Pack
>
How To Read Comma Separated Value (CSV-Flat Text) using biztalk server 2006
How To Read Comma Separated Value (CSV-Flat Text) using biztalk server 2006
- Hi All,I have a project where i have to read Comma Seperated value(CSV-Flat text) from FTP Server and then ..i need to store data in SQL table.Pls Advice how can i approach this to read the data ..RegardsSandeep
Answers
- Hi Sandeep,
Please follow the steps given below:
1. First Create the FlatFile schema using Flat File Schema wizard(You need to provide the instance of the flat file)
http://msdn.microsoft.com/en-us/library/aa577898(BTS.20).aspx
2. Now Add a Receive Pipline to your project. Place the Flat File Dissassembler componet from the tool box to the Dissassemble stage of the pipeline.
3. Deploy your solution.
4. Create a Receive Port and Receive location and Select the Custom Pipeline created by you in the pipeline section.
5. Create the SQL Send port and subscribed to this message.How to use the SQL Adapter you refer to below link
http://www.codeproject.com/KB/biztalk/usingsqladapter.aspx
Hope this will help you. For more details search on Bing.com you will find lot of documents relating to this.
Regards,
Abhijit
Abhijit Mahato Please "Mark as Answer" if Post has Answered the Question- Marked As Answer byAndrew_ZhuMSFT, ModeratorMonday, November 09, 2009 2:46 AM
- Proposed As Answer byRahulBizTalk Monday, November 02, 2009 6:00 PM
All Replies
- Hi Sandeep,
Please follow the steps given below:
1. First Create the FlatFile schema using Flat File Schema wizard(You need to provide the instance of the flat file)
http://msdn.microsoft.com/en-us/library/aa577898(BTS.20).aspx
2. Now Add a Receive Pipline to your project. Place the Flat File Dissassembler componet from the tool box to the Dissassemble stage of the pipeline.
3. Deploy your solution.
4. Create a Receive Port and Receive location and Select the Custom Pipeline created by you in the pipeline section.
5. Create the SQL Send port and subscribed to this message.How to use the SQL Adapter you refer to below link
http://www.codeproject.com/KB/biztalk/usingsqladapter.aspx
Hope this will help you. For more details search on Bing.com you will find lot of documents relating to this.
Regards,
Abhijit
Abhijit Mahato Please "Mark as Answer" if Post has Answered the Question- Marked As Answer byAndrew_ZhuMSFT, ModeratorMonday, November 09, 2009 2:46 AM
- Proposed As Answer byRahulBizTalk Monday, November 02, 2009 6:00 PM
- Hi Abhijit,Client wants to read excel file from FTP Server and wants that file should be there in FTP location after reading.Will file be consumed after reading.If yes then how can i retrieve only copy of file for further processing..
For this kind of assignment how much you think i should charge the clientThanksSandeep Handa - Hi Sandeep,
You need to develop a custom pipeline component to process Excel file in BizTalk.
Would suggest you to go through the below link:
http://www.codeproject.com/KB/biztalk/Excel_Read_Custompipeline.aspx
Regards,
Abhijit
Abhijit Mahato Please "Mark as Answer" if Post has Answered the Question- Proposed As Answer byRahulBizTalk Monday, November 02, 2009 6:00 PM
- Hi Abhijit,Can we able to use File Adapter to pull .csv file from FTP Server. Or i can only able to use FTP AdapterThanksSandeep
- Hi Sandeep,
If it is a FTP server then You have to use FTP adapter to pull file from FTP Server. You cant able to achieve this using FILE Adapter.
Regards,
Abhiit
Abhijit Mahato Please "Mark as Answer" if Post has Answered the Question
