SQL Server Performance

transfer xml data

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 10, 2007.

  1. fmardani New Member

    Using SSIS, how is it possible to transfer the content of an xml file into an xml/varchar(max) field of a table in sql server 2005?
    Thanks
    fmardani, Jul 10, 2007
    #2

  2. dineshasanka Moderator

    you can do this by using stored procedure

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Jul 10, 2007
    #2

  3. satya Moderator

    http://support.microsoft.com/kb/316005 too.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, Jul 10, 2007
    #2

  4. fmardani New Member

    quote:Originally posted by dineshasanka

    you can do this by using stored procedure

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/


    How? you mean using openxml? thanks
    fmardani, Jul 11, 2007
    #2

  5. Madhivanan Moderator

    Did you read the link satya provided?

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Jul 11, 2007
    #2

  6. fmardani New Member

    quote:Originally posted by Madhivanan

    Did you read the link satya provided?

    Madhivanan

    Failing to plan is Planning to fail

    Yes but do not want to use VB.
    I am using sql server 2005.
    Thanks
    fmardani, Jul 11, 2007
    #2

  7. satya Moderator

    XML Bulk load deals with loading up the data initially into SQL server. To update/delete, try thishttp://msdn2.microsoft.com/en-us/library/aa258671(SQL.80).aspx.

    As you know SQL Server 2005 has native XML datatype that you can store the whole xml doc in a sql table column without breaking it up and saving it as a table.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, Jul 11, 2007
    #2

  8. fmardani New Member

    ok, thanks
    fmardani, Jul 11, 2007
    #2

Share This Page