Hi,

I am expermenting with the SQL Server Import and Export Wizard in SSIS for
SQL Server 2005 (Developer Edition) to import xml files, I have set my Data
Source to be SQLXMLOLEDB.4.0 and clicked properties, then I have said where
the file is that I want to import and set the information to log on to the
server using Windows NT intergrated security and I have tired specifying the
username and password and when I come to test the connection I keep getting
the error -:

Test connection failed because of an error in initializing provider.
SQLOLEDB or SQLNCLI must be specified as the data provider.

I thought this is what I was setting at the outset of using the wizard but I
guess not, can someone point me in the right direction about what I am doing
wrong.

Thanks PD

Hi Phil,

I'm having the same issue. Set my data source to SQLXMLOLEDB4.0, go to
properties and enter the path of the file I want to import, and get
error message:

"SQLOLEDB or SQLNCLI must be specified as the data provider.
(SQLXMLOLEDB.4.0)"

when I test connection.

Have you found a solution?

Cheers,

Ben

*** Sent via Developersdex http://www.developersdex.com ***