Converting a flat file to XML then into sql

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Converting a flat file to XML then into sql

Viewing 1 reply thread
  • Author
    Posts
    • March 18, 2006 at 12:32 AM #13199
      community-content

        Hello I am new to BizTalk 2004. I am wondering if someone can reply with a link or an example of how I can conert a flat file to XML then insert the data into a sql table.
        In the simplest form my flat file looks like: for this example we will say it a comma delitmited file

        Definition —Owner,Animal, Age
        Bob, Horse, 3
        Dave, Dog, 7
        Debra, Lion, 5

        Thank You
        D

      • March 18, 2006 at 7:34 AM #13198
        community-content

          I am not clear about your exact requirment.
          In Sql Server If you already have the table where you want to transfer the data than you can create two scheam one for flat file and other for xml file having structure similar to sql server.
          Afterward you can use mapping to convert the data from flat file to xml.
          Once data is convert available then you can use the Sql Adapter to transfer the data to sql server.
          Basically you need to understand the three features:
          Creating Schema
          Mapping
          Orchestration or messaging: To create the output file.
          Adapter.

          You can find many example about this on MSDN or I will suggest you the book BizTalk Server 2004 Unleashed by Samps Publication.

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