SQL Server Performance

SQLXMLBulkLoad.3.0 with DSN connection

Discussion in 'SQL Server DTS-Related Questions' started by Guddu, Aug 23, 2007.

  1. Guddu New Member

    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
  2. satya Moderator

    What is the provider value?
    It should be provider=SQLOLEDB;" .
  3. Guddu New Member

    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
  4. satya Moderator

    You haven't tried with SQLOLEDB, as all the connection strings you refer are not this one.
  5. Guddu New Member

    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=xxx:pwd=xxx. or
    Provider="SQLOLEDB.1";DSN=xxx;UID=xxx:pwd=xxx.
    But still giving problem.
    Thanks and Regards,
    Shilpa
  6. satya Moderator

  7. Guddu New Member

    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

Share This Page