Post reply

SELECT values from XML column

  • July 17, 2008 at 4:33 am

    #189702

    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 🙂

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • July 17, 2008 at 5:13 am

    #844276

    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

    #844351

    Hi friends,

    I got solution myself by writing script.

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • August 1, 2008 at 1:51 pm

    #852161

    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

    #852178

    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

    #852805

    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 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply