| Todd C 2006-03-27, 1:33 pm |
| Using SQL Server 2005 Developer and Visual Studio 2005 Enterprise. I create a
new Project and new SSIS package. I create a new shared Data Source using SQL
native client and it test out OK. When I try to create a Connection Manager
in the package based on the shared Data Source, I get the following error:
************** start of error message ************
"The connection manager could not be created from one or more data sources.
Additional information:
> The connection type "OLEDB" specified for connection manager "{ <some long string here>}" is not recognized as a valid connection manager type. This error is retureed when an attempt is made to create a connection manager for an unknow connection type.
Check the spelling in the connection type name."
************* end of error message ************
If I try to create a new Connection Manager (not from a shared Data Source)
I only see a list of 4 possible drivers, not the huge long list I used to
see. I only have the following: MSMQ, SMOServer, SMTP, and WMI. I am missing
ADO, ADO.NET, EXCEL, and about 10 others that seem pretty standard (HTTP,
ODBC, etc)
I know that last week I was creating connection managers all over the place
and was not having this issue. Since then, I upgraded my Reporting Services
to 2005 (with much trouble), and also un-installed Visual Studio 2003. Could
any of these action have caused this? Just today, I completely un-installed
Visual Studio 2005 and re-installed. It did not help.
Any ideas?
Thanks in advance
|