I have a simple data flow task on my SSTS. It was working fine till
yesterday. When I tried to open the Package today, I got an error message and
was not able to open the Package.
Can anyone guide me on this issue? Below is what I get when I tried to open
the package.
Error 1 Error loading TermLookupSample.dtsx:
The connection type "OLEDB" specified for connection manager
"CWXPTDVZPT62.AdventureWorks_Destination"
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.
c:\sql 2005 ssis packages\sample 1\integration services project1\integration
services
project1\TermLookupSample.dtsx 1 1
Error 2 Error loading TermLookupSample.dtsx: Error loading value
"<DTS:ConnectionManager
xmlns

TS="www.microsoft.com/SqlServer/Dts"><DTS:Property
DTS:Name="ObjectName">CWXPTDVZPT62.AdventureWorks_ Destination</DTS:Property><DTS:Property
DTS:Name="DTSID">{FF73A7B2-8FA7-4532-A5A4-9846AA8A66B0}</DTS:Property><DTS:Property D" from
node "DTS:ConnectionManager". This happens when saving fails. c:\sql 2005
ssis
packages\sample 1\integration services project1\integration services
project1\TermLookupSample.dtsx 1 1
Thanks in Advance
Mahesh