none
How To Read Comma Separated Value (CSV-Flat Text) using biztalk server 2006 RRS feed

  • Question

  • 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 ..

    Regards
    Sandeep


    Monday, November 2, 2009 5:54 AM

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
    Monday, November 2, 2009 7:47 AM

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
    Monday, November 2, 2009 7:47 AM
  • 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 client
    Thanks
    Sandeep Handa
    Monday, November 2, 2009 8:56 AM
  • 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 by RahulBizTalk Monday, November 2, 2009 6:00 PM
    Monday, November 2, 2009 9:58 AM
  • Hi Abhijit,
    Can we able to use File Adapter to pull .csv file from FTP Server. Or i can only able to use FTP Adapter
    Thanks
    Sandeep
    Thursday, November 5, 2009 7:23 AM
  • 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
    • Proposed as answer by AmitBTS Tuesday, February 23, 2010 4:40 PM
    Thursday, November 5, 2009 8:27 AM