General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Title:
Problem opening dtsx package
Environment versions
SQL Server:
SQL Server 2014
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only