SQLXMLBulkLoad.3.0 with DSN connection

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 ServerHelp file:Help context: 0What is the solution for this?Any help is appreciated.Thanks in advance.Shilpa

Hi Satya,
Thanks for the Reply.
I have tried many connection strings but no luck.
The analysis of the same is this.
1. ConnectionString:
Provider=MSDASQL.1;Persist Security Info=False;User ID=xxx;Extended Properties="DSN=xxx;Description=xxx;UID=xxx;APP=Microsoft® Windows® Operating System;WSID=CWDHTFDHOXFPO16;DATABASE=xxx";Initial Catalog=xxx
Provider:
Microsoft OLEDB provider for ODBC drivers
DSN:
System DSN with SQL authentication.
Error:
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Error connecting to the data source.
Error source: Microsoft XML Bulkload for SQL Server
Help file:
Help context: 0
2. Connection String:
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=xxx;Description=xxx;APP=Microsoft® Windows® Operating System;WSID=CWDHTFDHOXFPO16;Trusted_Connection=Yes";Initial Catalog=xxx
Provider:
Microsoft OLEDB provider for ODBC drivers
DSN:
System DSN with windows authentication.
Error:
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Error connecting to the data source.
Error source: Microsoft XML Bulkload for SQL Server
Help file:
Help context: 0
3.ConnectionString:
By choosing the data source name from drop down list the name of DSN.
Provider=MSDASQL.1;Persist Security Info=False;User ID=xxx;Password=xxx;Data Source=xxx;Initial Catalog=xxx
Provider:
Microsoft OLEDB provider for ODBC drivers
Error:
Sql server does not exist or access denied.
Any help is appreciated.
Shilpa

Hi Satya,
Sorry i didnt mention that.
I have also tried with Provider="SQLOLEDB" and Provider="SQLOLEDB.1".
For eg in this case the connection string is Provider="SQLOLEDB";DSN=xxx;UID=xxxwd=xxx. or
Provider="SQLOLEDB.1";DSN=xxx;UID=xxxwd=xxx.
But still giving problem.
Thanks and Regards,
Shilpa

Hi Satya,
Thanks for reply.
Both articles doesnot contain the connection string for DSN.
My concern is only DSN connection with SQLXMLBulkLoad.3.0.
Please Reply soon.
Thanks.
Shilpa