Post reply

Loading Xml Files Into Sqlserver Tables By Using SSIS 2012

  • April 6, 2015 at 6:33 am

    #316134

    Good Evening All,

    Currently we are trying to load the xml files into sqlserver tables by using ssis 2012,

    We are getting xml files as a column in source table ,so we have to push these xml files into destination tables.

    I'm following the below way to perform this activity

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/96579/

    But We have standard XSD structure for all the xml files ,and if xml file matches the XSD structure then only

    we have to load ,else it should skip to next xml file.

    So,is any one got experience on these type of requirement and if yes ,kindly share your knowledge.

    Regards,

    Saikumar

  • April 7, 2015 at 10:55 am

    #1789269

    saikumar.mca2007 (4/6/2015)

    Good Evening All,

    Currently we are trying to load the xml files into sqlserver tables by using ssis 2012,

    We are getting xml files as a column in source table ,so we have to push these xml files into destination tables.

    I'm following the below way to perform this activity

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/96579/

    But We have standard XSD structure for all the xml files ,and if xml file matches the XSD structure then only

    we have to load ,else it should skip to next xml file.

    So,is any one got experience on these type of requirement and if yes ,kindly share your knowledge.

    Regards,

    Saikumar

    I am afraid this will be rather complex when you need to validate against XSD.You could use EF (Entity Framework) to build an object out of xsd and validate your xml. The other route would be to use Xquery.

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

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