Is it possible to parse & load an xml file with optional elements/attributes using SQL Server Integration Service 2005? Any examples/pointers would be appreciated.
+1
A:
You can parse it an xml CLOB using T-SQL constructs now: SO search for SQL Server and xml tags
I think it would be clumsy using SSIS.
Do you have to use SSIS particularly?
gbn
2009-07-15 18:52:08
I've used SSIS to import complex XML before. It was a win because of the amount of defaulting and consistency checking that was necessary before the data could be imported. It's also quite fast, especially so in the 2008 version.
John Saunders
2009-07-15 18:58:28
@John: Fair enough. I've used XQuery in T-SQL wfor smaller, well defined schema. It depends on what OP wants to do, really.
gbn
2009-07-15 19:02:12
@John: Can you please explain the steps needed to import that XML data?
Abdullah Jibaly
2009-07-15 19:05:06
See http://stackoverflow.com/questions/687913/what-is-the-largest-xml-file-ssis-can-extract-data-from/687976#687976 and let me know if you need more information after that. It's pretty long, but could use pictures.
John Saunders
2009-07-15 20:23:17