MS SQL XML - SQLXMLBULKLOAD3.0 Error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQLXMLBULKLOAD3.0 Error

battepatiharsha

2005-09-12, 8:24 pm

i wrote the following code in a Active x script task in a DTS package
to import the data from XML document. i have saved XML and XSD
documents to the hard disk. while running the DTS package i have been
getting the following error message:
"Error connecting data source"

Here is the VB script :
Dim objXBulkLoad
Set objXBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")

objXBulkLoad.ConnectionString =
"PROVIDER=SQLOLEDB.1;SERVER=. ;UID=sa;PWD=;DATABAS
E=NorthWind;"

objXBulkLoad.KeepIdentity = False

'Optional Settings
objXBulkLoad.ErrorLogFile = "c:\NWError.LOG"
objXBulkLoad.TempFilePath = "c:\temp"

'Executing the bulk-load
objXBulkLoad.Execute "c:\books.xsd", "c:\books.xml"

Main = DTSTaskExecResult_Su
ccess

please advice. i really appreciate your help

Sponsored Links