dbTalk Databases Forums  

Error Openning SSIS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error Openning SSIS Package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mahesh
 
Posts: n/a

Default Error Openning SSIS Package - 08-11-2005 , 12:30 PM






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
xmlnsTS="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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.