SQLXMLBulkLoad.3.0 with DSN connection

[Shilpa Ginode]

Hi All,

I have a problem regarding SQLXMLBulkLoad. 3.0 and the DSN connection.

I have created a object of SQLXMLBulkLoad. 3.0 in my DTS package.
The connection for this object is DSN connection.
The connection string is "DSN=xx;uid=xxx ;pwd=xxx".

But while executing the DTS package i got the following error:
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Error creating a session.
Error source: Microsoft XML Bulkload for SQL Server
Help file:
Help context: 0

What is the solution for this?

Any help is appreciated.
Thanks in advance.
Shilpa

[Dököll]

What is the solution for this?

Any help is appreciated.
Thanks in advance.
Shilpa

Hiya, Shilpa Ginode!

Has the code previously worked? Are you allowed to connect to the server?

I will do some digging meanwhile...

Please stay tuned!