none
copying Exel file into Sql Tables using biztalk RRS feed

  • Question

  • Hi,

    Please tell me,

    How to copy an excel file into database tables from receive File handler to Sql send Handler using biztalk, when the stored procedure is based on table type in which single table type consists of all parametres of multiple tablels and stored procedure consists of only 2 parametres.

    ==============

    Thanks,

    Prabhakar.

    Friday, January 4, 2013 12:39 PM

Answers

  • step1 :create Biztalk Application that can receive Excel. for this custom pipeline is required which can receive Excel .

    refer Article, for creating Excel pipeline .

    Step 2:Create stored procedure

    Step 3 : create schema for stored procedure using wcf-sql adapter.

    Step 4 : create Map for transform excel xml to stored procedure xml

    Step 5 : deploy and configure application .

    Regards

    Mohit gupta

    Friday, January 4, 2013 12:51 PM

All replies

  • step1 :create Biztalk Application that can receive Excel. for this custom pipeline is required which can receive Excel .

    refer Article, for creating Excel pipeline .

    Step 2:Create stored procedure

    Step 3 : create schema for stored procedure using wcf-sql adapter.

    Step 4 : create Map for transform excel xml to stored procedure xml

    Step 5 : deploy and configure application .

    Regards

    Mohit gupta

    Friday, January 4, 2013 12:51 PM
  • Hi Prabhakar,

    Are you trying to add the data within the excel file into the database?  To do this you will need to use a custom pipeline component to convert the excel file to XML, then map this to your SQL schema.  BizTalk doesn't support excel to XML out of the box.  One free pipeline can be downloaded from codeplex here.

    If you just want to copy the actual file into the DB you should be able to create a BLOB stream from it and save it directly to the database, however this will just be as a BLOB of the .xls file.



    GilesB

    • Proposed as answer by GilesB1 Tuesday, January 8, 2013 1:36 PM
    Friday, January 4, 2013 12:51 PM