Post reply

bulk insert from xml to SQL server 2000

  • January 27, 2004 at 6:56 am

    #59640

    How can bulk data insert be done from xml files into SQL server 2000 tables through DTS ?

     

  • January 28, 2004 at 9:37 am

    #492010

    I'm a newbie too - so maybe someone knows different. You can't do it with Bulk Insert Task. You can do an xml Bulk insert with SQLXML bulk load though.

     

     

  • January 28, 2004 at 9:43 am

    #492013

    Nevermind - Yes you can. There is a section on this in a book called SQL Server XML Distilled (curlingstone press)

    Essentially use a vb script to execute SQLXML BulkLoad. You could download the example from Curlingstone.

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

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