Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lexiz
Starting Member
17 Posts |
 Posted - 2010-08-13 : 09:39:34
|
| hi folks,sorry if this is in the wrong section, im clueless enough not to know.I have some Language files (***.resx) which are XML. I want to ideally manipulate, read in to a sql server table (do some stuff with the data), then back into the the .resx file. Ive been using sql server since 6.5 so im fine with sql server stuff, but dont have a clue about:a> how the best way to go about this is? (advice whould be good)b> what I should reading up on exactly? (any good links on the subject would be great!)thanks in advance for feedback ;) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-14 : 03:03:48
|
| you can use SSIS for that. do you want to transfer XML as it is or shred the data?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
lexiz
Starting Member
17 Posts |
Posted - 2010-08-14 : 09:26:35
|
| I want to shred the data into a table, then back again later from a table into xml, so I should be looking at ssis then? |
|
|
|
lexiz
Starting Member
17 Posts |
Posted - 2010-08-14 : 10:14:10
|
| I only have express which i dont think has ssis... ;-( |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-14 : 13:05:08
|
| then you need to use BULK INSERT i guess------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-14 : 13:57:43
|
| OPENXML is a possibility, but it doesn't read files directly. You'd have to insert the XML as a BLOB into a table and then into an XML or nvarchar(max) variable. It's a bit clunky to use, and once you get the XML into a table or variable you can use XQuery and the regular XML methods to extract data.For generating tabular data as XML, the FOR XML options will work, but getting them into a file will be tricky without SSIS.There's some good information here (copy and paste link, click won't work): http://msdn.microsoft.com/en-us/library/ms345117(SQL.90).aspx |
|
|
|
|
|
|
|
|
XML files