Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem opening dtsx package
Message
From
26/11/2015 04:30:29
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Title:
Problem opening dtsx package
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01627914
Message ID:
01627914
Views:
42
I'm getting this error when I try to open a dtsx package in the Visual Studio 2013 designer.


88 Error loading 'StagingToCRM.dtsx' : The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.

There's a lot of errors before this one. They all seem to be connection problems.

eg

Error 3 An error has occurred while connecting CRMStaging: Exception from HRESULT: 0xC0202009. Package 0 0


Error 4 Validation error. Load AccountPreLoadCopy: Package: The connection manager "CRMStaging" will not acquire a connection because the connection manager OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired. Package.dtsx 0 0


people working at the site tell me they can open the package ok on the server. I'm trying to open it locally.


Any ideas how I work out what the problem is ? I don't need to run the package locally but I'd like to be able to look through it.



Thanks

Nick
Next
Reply
Map
View

Click here to load this message in the networking platform