January 28, 2016 at 11:37 am
Working on package, tried to create a merge and info on the web said to set 'Run64BitRuntime' in the project debugging properties to "True". Left the package for a bit to work on another in the same project (which runs), and got the following error:
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: 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. ---> System.Runtime.InteropServices.COMException: 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. at
Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents100 pEvents) at
Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral) --- End of inner exception stack trace --- at
Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral) at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events) at Microsoft.DataTransformationServices.Project.ProjectBuildItemInfo.Update(DateTime lastWriteTime, PackageItem packageItem, Project project, String projectDirectory) at
Microsoft.DataTransformationServices.Project.ProjectBuildValidator.RefreshCache(PackageItem item) at
Microsoft.DataTransformationServices.Project.ProjectBuildValidator.CheckBuildItem(PackageItem item) at
Microsoft.DataTransformationServices.Project.ProjectBuildValidator.CheckConsistency(String& errors, String buildLogFullName) at
Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.IncrementalBuildThroughObj(IOutputWindow outputWindow) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.BuildIncremental(IOutputWindow outputWindow)
I put the debug option, Run64BitRuntime back to FALSE and I still have the error. I've looked around the internet and can't find this exact error. I'm running VS2012 and SQL2012R2.
Any ideas?
It doesn't appear to hamper the running of any projects, but I have no idea what's going to happen when I try to deploy this one fully.
January 28, 2016 at 12:07 pm
What do you mean by the following?
tried to create a merge
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 28, 2016 at 1:09 pm
I was merging the results of two flat file loads. Both flat files have unique data. They both have same # of columns with the same data types.
I need to merge the flat files and then load to an SQL2012 table. Nothing out of the ordinary.
I've now deleted everything in the "offending" package except a single flat file load. Still have the same error.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply