MS SQL XML - SQLXML bulk import frustrations!!!

Author

SQLXML bulk import frustrations!!!

Tim Greenwood

2005-12-02, 1:23 pm

I'm NOT new to this(SQL Server in general) so I'm not sure why I'm
experiencing so much frustration. I AM new to SQLXML though I've a bit of
experience with the XML itself. I've been trying to bulk load a pricing
file using an example script I gleaned directly from Microsoft.
---------------------------------------------
Dim objXBulkLoad
Set objXBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")

objXBulkLoad.ConnectionString =
"PROVIDER=SQLOLEDB. 1;SERVER=localhost;i
ntegrated
security=SSPI;DATABA
SE=products;"

objXBulkLoad.KeepIdentity = False

'Optional Settings
objXBulkLoad.ErrorLogFile = "c:\NWError.LOG"
objXBulkLoad.TempFilePath = "c:\"
objXBulkLoad.CheckConstraints = False
objXBulkLoad.SchemaGen = True

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

Main = DTSTaskExecResult_Su
ccess
-----------------------------------------------------

I get "Error on Line 14 - Error connecting to the data source.". I've tried
just for kicks using the same technique in C# and of course get the same
results.

Yes, the xml and schema files are definitely there. When I first start the
DTS off I can see the activity on my hard disk pickup like it is reading.
It's a 30MB file and I'm wondering if it is a possibility that something is
timing out waiting for the source. Really stuck here and have a group of
folks waiting on me....

Any help is soooo much appreciated.

Nader Shahin

2005-12-06, 8:25 pm

Your problem is an Authentication problem.
Try to use SQL authentication.
If it works so you need to add privileges to bwsql user.

Thanks,
Nader Shahin

"Tim Greenwood" wrote:

> I'm NOT new to this(SQL Server in general) so I'm not sure why I'm
> experiencing so much frustration. I AM new to SQLXML though I've a bit of
> experience with the XML itself. I've been trying to bulk load a pricing
> file using an example script I gleaned directly from Microsoft.
> ---------------------------------------------
> Dim objXBulkLoad
> Set objXBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
>
> objXBulkLoad.ConnectionString =
> "PROVIDER=SQLOLEDB. 1;SERVER=localhost;i
ntegrated
> security=SSPI;DATABA
SE=products;"
>
> objXBulkLoad.KeepIdentity = False
>
> 'Optional Settings
> objXBulkLoad.ErrorLogFile = "c:\NWError.LOG"
> objXBulkLoad.TempFilePath = "c:\"
> objXBulkLoad.CheckConstraints = False
> objXBulkLoad.SchemaGen = True
>
> 'Executing the bulk-load
> objXBulkLoad.Execute "c:\ProductExtract.xsd", "c:\prod11-23.xml"
>
> Main = DTSTaskExecResult_Su
ccess
> -----------------------------------------------------
>
>
> I get "Error on Line 14 - Error connecting to the data source.". I've tried
> just for kicks using the same technique in C# and of course get the same
> results.
>
> Yes, the xml and schema files are definitely there. When I first start the
> DTS off I can see the activity on my hard disk pickup like it is reading.
> It's a 30MB file and I'm wondering if it is a possibility that something is
> timing out waiting for the source. Really stuck here and have a group of
> folks waiting on me....
>
> Any help is soooo much appreciated.
>
>
>

Sponsored Links