NytroZ
asked on
Convert XML to tables in SQL
Is there a feature or a third party tool that will convert XML data into a table in SQL 2008?
NO Points pl.
@Tony303
check out EE articles by ValentinoV
Loading XML Using SSIS
Loading Complex XML Using SSIS
{+ edit, humble apologies for the multiple alerts}
I should add re-use of material within experts-exchange.com is encouraged.
@Tony303
check out EE articles by ValentinoV
Loading XML Using SSIS
Loading Complex XML Using SSIS
{+ edit, humble apologies for the multiple alerts}
I should add re-use of material within experts-exchange.com is encouraged.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'll add the article URL's if you don't (hint)
re: chastised
sorry, no offense intended at all, I'm not terribly subtle though - or if I try to be it fails.
re: torszula
sounds delicious. Mexican?
re: chastised
sorry, no offense intended at all, I'm not terribly subtle though - or if I try to be it fails.
re: torszula
sounds delicious. Mexican?
ASKER
So in short, importing XML data into a SQL db is definitely workable with the right SQL guy on the job. Thanks!
Not Mexican but many a women have found delicious none the less! think pierogis!
Not Mexican but many a women have found delicious none the less! think pierogis!
ASKER
I have enough information to contact a qualified engineer for help with the migration.
Thanks
Thanks
You can use SSIS to import XML.
Here is a working example.
Quite a bit of work.
{link deleted, PP}