Send a text file,and insert its data in an orchestration

Home Page Forums BizTalk 2004 – BizTalk 2010 Send a text file,and insert its data in an orchestration

Viewing 1 reply thread
  • Author
    Posts
    • #15204

      😀 Hi!!
      I have 2 doubts with an orchestration: this have a send port, and I want to insert the data of the xml file (with two records -id,name,and address- )in a sql server 2000 table…and then I wan%u00b4t to send that xml file to a folder location, but convert in a text file…
      I built perfectly the xml file, but the exit piperline with a dissambler flat file doesn%u00b4t work… and I don%u00b4t know how to do the inserts on the table…
      Any idea??

      Thanks!
      (pd: I have biztalk 2006 and sql server 2000)

    • #15205

      To Insert Data to SQL-Server you should use the SQLAdapter. There are lots of examples how to use the sql-adapter.

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