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.
相关问题
- keeping one connection to DB or opening closing pe
- SQL Server Import Wizard doesn't support impor
- Quickest method for matching nested XML data again
- Bulk insert from excel to sql for selective fields
- What are IN and OUT parameter in SQL Server
相关文章
- SSIS solution on GIT?
- Convert column to string in SQL Select
- Why not “Invalid column name XYZ” error in subquer
- Create @TableVariable based on an existing databas
- How can I manually fail a package in Integration S
- Convert bit type to Yes or No by query Sql Server
- See complete tooltip error message for Data Flow S
- Save content of Email body in outlook to a file
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?