I have to create a SSIS package which will take data from a large xml file(~10GB), and import it into sql server 2005 database. Can anyone tell me the steps which i have to follow to do this? I also have to do XSD validation and maitain Transaction.
N
ntiin
@ntiin
Posts
-
SSIS Package to import XML file in Sql server 2005 Database -
Huge Xml Document(more than 10GB) import to Sql Server 2005Yes this is not much helpful for me . i am tring SSIS Package to do so. Can anyone help me on topic "SSIS Package for Importing XML files"?
-
Huge Xml Document(more than 10GB) import to Sql Server 2005I have 2GB RAM in my machine. i tried SSIS package for 1.5GB file it's giving error. Error: 0xC02092AF at Data Flow Task, XML Source [1]: The component "XML Source" (1) was unable to process the XML data. Insufficient memory to continue the execution of the program. If SSIS is not right choice than i have to follow the process as jschell suggest. can anyone give me some code sample for splitinf file into smaller one. i can split 10GB file into 10 1GB smaller files not more. If i process 10 1GB files than how can i maintain transaction in all files? i mean to say if 1 file fails all others files should be rollbacked.
-
Huge Xml Document(more than 10GB) import to Sql Server 2005Thanks for your Reply. i apologize for reposting question in Asp.net and c#. Would SSIS be capable for importing data from Large Xml Document(more than 10GB)? did you try it?
-
Huge Xml Document(more than 10GB) import to Sql Server 2005i 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?
-
Huge Xml Document(more than 10GB) import to Sql Server 2005i 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?
-
Huge Xml Document(more than 10GB) import to Sql Server 2005 [modified]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?
modified on Monday, April 18, 2011 6:12 AM