July 17, 2008 at 4:33 am
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
July 17, 2008 at 5:13 am
What's the structure of the XML?
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
July 17, 2008 at 7:02 am
August 1, 2008 at 1:51 pm
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
August 1, 2008 at 2:24 pm
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.
August 4, 2008 at 11:29 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy