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:
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?
