Hi ,
I am importing data from an xml file that validates itself against a schema. I need to import some of the values to the corresponding columns in the table. Other elements will be inserted to the a column of type XML.
The size of the file is about 500+MB. I have already tried SSIS. It does not validate my schema, in spite of the fact that the schema is valid. I tried to copy using SQLXML Bulk Insert, but this does not suit to my particular situation.
I am using SQL Server 2005.
What are my options? Any examples / code samples will do.
Thank you,
Zaboo
What is it about SQLXML that doesn't suit your needs?
How about some sample data, ddl, etc.?
No comments:
Post a Comment