Debatch a flat file and drop in database

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Debatch a flat file and drop in database

Viewing 2 reply threads
  • Author
    Posts
    • July 26, 2010 at 3:38 PM #25381
      community-content

        Hi,

           I would like to know, the best approach to debatch a flat file and drop each row into a DB table.

        I was able to debatch file using flat file schema wizard and a pipeline component, to drop single files into a folder. But, I would like to drop each of the row in flat file to a sql table.

        Please advice.

         

        thanks,

        UHCLStud

         

      • July 26, 2010 at 9:15 PM #25382
        community-content

          Hi,

           

             The better approach depends on how many rows of data from the debatched flat file you are expecting to insert into a DB table. Is it in the hundreds? Thousands? Millions?

              If you have a fairly small set of records and don’t expect it to grow or vary widely over time, I would recommend using WCF SQL Adapter to insert the rows into the DB table.

              If you have a large set of records (i.e. think ETL, datawarehouse style), you should look into implementing a custom .NET helper class (that can invoke the BCP program from the command line, bulk copying your records in an efficient and fast way to your DB table) that can be called from BizTalk.

           

              Hope this helps,

           

              Daniel.

           

        • November 20, 2020 at 12:45 AM #50500
          biztalkgurus

            Six Acres and a Third: The Classic Nineteenth-Century Novel about Colonial India by Fakir Mohan Senapati : 9780520228832

        • Author
          Posts
        Viewing 2 reply threads
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.