Post reply

Huge Xml Document(more than 10GB) import to Sql Server 2005

  • April 19, 2011 at 4:33 am

    #74355

    i have to import xml document having size more than 10GB in Sql Server database. i also have to do XSD Validation before Processing and maintain transaction. Please suggest me the best way to do the same. should i use SSIS packege? is it capable of Processing such large document? or Do i have to use c# coding to accomplish this task?

    My machine have 2GB of RAM and 40GB Free Space.

  • April 27, 2011 at 10:11 pm

    #1317019

    yes you should be able to import 10GB file with SSIS XML Source without any issue.

    -----------------------

    document sql server database | ssis custom tasks

  • May 10, 2011 at 7:32 am

    #1322286

    You can use the XSD validation in SSIS. However, C# allows you to do more granular error checking, as opposed to doing XML structure validation. If you need to accommodate for errors in data as well as errors in XML structure, then a C# task would be more of the way to go.

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

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