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.dtsx: 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_PartNumbers.dtsx 1 1
Any idea how I fix this? All of the packages say the same thing now.