Friday, March 9, 2012

Errors during import and export

I am unable to import anything from one sql 2000 database to another using the 2005 Management Studio - When I try I get an error similar to this -

Could not set up data flow connections.

The connection type "OLEDB" specified for connection manager {ccccc}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
(SQL Server Import and Export Wizard)

Thanks Richard

I saw this solution on another MSDN forum which worked for me:

"It is a SSIS issue. Open SQL Server Configuration Manager. Right click on SQL Server Integration Services. Select properties and in the Log On tab change the built-in account."

I'm only a newbie to this so I don't know what the implications of this change are, other than I was able to import my Access Db.

No comments:

Post a Comment