April 12, 2003 at 4:24 pm
Last week I got a request to import data, daily, from an XML file into our Sql database. Can DTS import XML? (sure it can read the XML text file but parsing the file is quite another matter!)
Bill
April 15, 2003 at 8:00 am
This was removed by the editor as SPAM
April 15, 2003 at 8:41 am
My real answer is I don't know - but you could always use OpenXML. Isn't there a bulk load for XML now as well?
Andy
April 16, 2003 at 5:07 am
Yes - the bulk load com interface is in sqlxml 3.0 sp1 which is free to download. As far as I know there's no intrinsic support in DTS although the ParallelDataPumpTask seems as though it would be particularly useful in this regard - presumably Yukon will have more inbuilt support.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply