Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  SQLXMLBulkLoad.3.0 with DSN connection

Author  Topic  Guddu Starting Member 1 Post Posted - 2007-08-23 : 04:32:00 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