SELECT values from XML column
-
Hi Friends,
I am good in T-SQL but new to XML data type.
I am creating a SSIS Package in which I need to extract data from XML columns and save the data in SQL Server Table (Destination)
My Source Table Looks like:
TableName: EmpInfo
ID int IDENTITY,
EmpFirstName varchar(50)
EmpMiddleName varchar(50)
EmpLastName varchar(50)
Details XML
here, Details feilds contains information like Local Address, Permanent Address, Phone No etc.
My Destination Table Looks like:
TableName: EmpInfo
ID int IDENTITY,
EmpFirstName varchar(50)
EmpMiddleName varchar(50)
EmpLastName varchar(50)
LocalAddress varchar(50)
PermanentAddress varchar(50)
PhoneNo varchar(20)
Now, I think you got my point. I need to extract the first four columns as it is but remaing three columns from XML columns.
How I can do it in SSIS or even in T-SQL?
Thanks in advance
-
What's the structure of the XML?
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
-
Hi,
Can you help me, please?
How do you resolve the problem? I'm use a XML Task for read a XML file, but I could not resolve. For example, I don't know how to configure a component.
I'm sorry my english, because I'm brazilian and it's my frist email in english.
Tanks for all.
Érika Araujo
-
What are you trying to do?
XML to SQL?
are u using SSIS for same?
u can use a data flow task and there take XML source, configure it to give XML file and XSD
then use either OLDEDB or SQL server destination.
-
Hi. Tanks for help.
Yes I'm using all components you said, but my problem is witch the XML file. This utf configuration is 16, and the XSD is 8. So, when I put these files in the XML Source this component show me an error. In another hand when I change the XSD utf configuration for 16, the SSIS complains me about can’t support Unicode.
I don’t know if you understand me.
Well, tanks for all.
Érika Araujo.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply