Post reply

Importing mutiple XSD schemas and XML files

  • November 17, 2011 at 2:26 am

    #247940

    Hello Members,

    I need to import multiple xsd schema's and multiple xml files into the sql server 2005 db. Can this be done using ssis package ? Is there any other way to do this ?

    Thanks in advance!!

  • November 20, 2011 at 7:27 pm

    #1410462

    alladiz (11/17/2011)

    Hello Members,

    I need to import multiple xsd schema's and multiple xml files into the sql server 2005 db. Can this be done using ssis package ? Is there any other way to do this ?

    Thanks in advance!!

    Because the SSIS data flow metadata is statically defined during design time, you have to create separate Data Flow Task to import each type of xml file.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply