Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML to SQL conversion Expand / Collapse
Author
Message
Posted Tuesday, May 27, 2014 9:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 12, 2015 4:35 AM
Points: 100, Visits: 462
I have the following XML file and want inserting into a SQL table, the problem I am having is that the XML has two row nodes.
These need to be inserted into one row, when I code the insert the xml is spread over two rows.
Could any body help.

Cheers
Post #1574839
Posted Tuesday, May 27, 2014 9:45 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 1:59 PM
Points: 427, Visits: 2,284
clucasi (5/27/2014)
I have the following XML file and want inserting into a SQL table, the problem I am having is that the XML has two row nodes.
These need to be inserted into one row, when I code the insert the xml is spread over two rows.
Could any body help.

Cheers


Hi there. I don't see any example code or attachment. Also, if this is just an XML question and has nothing to do with CLR / .Net integration, then maybe the question should be posted to a general SQL programming forum?





SQL# - http://www.SQLsharp.com/
Post #1574849
Posted Tuesday, August 12, 2014 11:50 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 3, 2015 12:35 PM
Points: 573, Visits: 1,229
It helps to be able to see what you are seeing. If this is still an issue for you can you post a sample of your xml data? Have you looked into the XML source in SSIS?
Post #1602395
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse