load data with file to database oracle and SQL Server in biztalk

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › load data with file to database oracle and SQL Server in biztalk

Viewing 1 reply thread
  • Author
    Posts
    • September 6, 2006 at 9:44 AM #15575
      community-content

        Dear recipient:

        I want to load data from file to database in oracle or SQL Server in biztalk, I dont know who make this.

        Can you help me please??

        Thanks for your help.

        Regards. 

         

      • September 6, 2006 at 10:14 AM #15576
        community-content

          This job will do SQL Adater, Comes with BizTalk, u can use Datagram and create a schema. then map from flat file schema to SQL Schema.

          You can workout StoreProcedues or Querys, both workes here.

          BizTalk 2006 got Oracle Adapter too….

          Hope it helps you.

          Nar- 

           

           

          • September 8, 2006 at 3:21 PM #15627
            community-content

              [quote user="Nar_BTS"]

              This job will do SQL Adater, Comes with BizTalk, u can use Datagram and create a schema. then map from flat file schema to SQL Schema.

              You can workout StoreProcedues or Querys, both workes here.

              BizTalk 2006 got Oracle Adapter too….

              Hope it helps you.

              Nar- 

               

              Dear Nar:

              If I need in biztalk extract information of database oracle and transform datos and then insert this information in other database Informix how do you recomended this for run automatic, with store procedure or sql adapter??? 

              I beginner in biztalk, now read documentation for know.

              Thanks for your help.

              Regards. 

               

              [/quote]

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