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 |
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-11-21 : 09:54:14
|
Guys -I'm a totally newbie on xml, I've been involved in a project where I'll need to query and import data from xml files into sql 2000 tables, can anyone tell me what steps to take or links that will help me understand more about xml ?Are there any tools on dts designer that allows me to load xml data directly into a sql table ?---"There's no sexy way to carry a lunch bag." My boss |
|
X002548
Not Just a Number
15586 Posts |
Posted - 2006-11-21 : 10:06:09
|
got some sample data?There'sa a boatload of info in books online, for examplCREATE PROC sp_insert_employee @empdata ntext AS DECLARE @hDoc int EXEC sp_xml_preparedocument @hDoc OUTPUT, @empdata INSERT INTO Employee SELECT * FROM OPENXML(@hDoc, '/Employee') WITH Employee EXEC sp_xml_removedocument @hDoc But I have no experience here, nor have found any reason to obtain anyBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-21 : 10:06:17
|
This is the best summary of all your options that I've seen.http://www.yukonxml.com/articles/sql2000xml/ |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-11-21 : 10:31:04
|
X002548 -No data yet, seems like they're trowing me the easy stuff, it'll be a data from a survey that will be stored on a xml file.snSQL -That link is pretty sweet, the "DTS ActiveX Script & SQLXML 3.0 Bulk Load" section might do what I need.---"There's no sexy way to carry a lunch bag." My boss |
|
|
|
|
|