sbornstein2
asked on
The connection type "OLEDB" specified for connection manager "Microsoft OLE DB Provider for SQL Server" is not recognized as a valid connection manager type. - DTSX packages keep saying corrupted
Hello all. I am having a problem on our SQL 2005 box where anytime I try to open a dtsx file which used to open fine is now saying:
Error loading Update_OEM_PartNumbers.dts x: The connection type "OLEDB" specified for connection manager "Microsoft OLE DB Provider for SQL Server" 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. D:\SQLSSIS\Update_OEM_Part Numbers.dt sx 1 1
Any idea how I fix this? All of the packages say the same thing now.
Error loading Update_OEM_PartNumbers.dts
Any idea how I fix this? All of the packages say the same thing now.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
http://support.microsoft.com/default.aspx?scid=kb;en-us;913817
ran the program but no invalid keys came up.