i have set up a dts to bulk load a xml file from the loacl drive this works
fine

is it posssible to set the dts to get the xml from a url

i.e

objXBulkLoad.Execute "e:\xml\saleschema.xml", "http://website/sale.xml"

if so what do i need to do in the dts if not if is there a diffent option

Regards

Nick Kearns

Nick Kearns wrote:
I don't think there's a way to have the bulk loader get the XML from a
URL, but you can have an ActiveX script task that retrieves the XML file
and saves it for you. It could invoke a utility like wget.exe (not
included with Windows) to download the file.