Sql

  • I Need uploading an XML file to SQL Server... The scipt should use MS SQL Server Bulk import capability (OpenXML)...How can i do this.

  • your request is not clear:

    from what i can gather from your request

    1. You have an xml file with records that you want to import into sql table(s).

    i don't think you can use bulk import that way. you have to use dts with a stored proc. When I had a similar problem I used a vb .net front end and stored procs to import data.

    you can also have a look at this article

    http://www.sqlservercentral.com/columnists/smoore/importingxmlfilesintosqlserver.asp


    Everything you can imagine is real.

Viewing 2 posts - 1 through 1 (of 1 total)

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