Post reply

XML to SQL server

  • April 21, 2008 at 3:24 pm

    #71839

    What is the best way to import a XML file over the web (http:\\Name.xml) .

    Using

    SQL server 2000 (T-SQL)

    VBScript ?

    DTS process ?

    sp_OA* procks?

    ...

    with out using:

    1.SQLXMLBulkLoad(as there are extra steps creating schema)

    2.xp_cmdshell

    Thanks

  • April 23, 2008 at 4:58 am

    #805974

    Best way according to what criteria?

    In SQL 2000 using a client application to parse XML data is your best option. Don't use SQL Server for tasks it's not good at.

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

  • April 24, 2008 at 6:10 am

    #806494

    Thanks You,.. kind of answered my question in a way. I was thinking of importing XML file to SQL and Automating the process, so was looking into different options....Seems like neat way to do is using VB script or some thing like that....

  • July 1, 2010 at 7:51 am

    #1187663

    Hey!

    Got any solution for that?

    That'd be greate!

Viewing 4 posts - 1 through 3 (of 3 total)

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