SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The package failed to load due to error 0xC0010014 "One or more error occurred.


The package failed to load due to error 0xC0010014 "One or more error occurred.

Author
Message
kushalfree99
kushalfree99
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 0
Guys, I had same issue. Here is the solutions...

What you need to do to isolate the problem is go to your SQL Server 2005 binn directory and rename your DTExec.exe to DTExec.exe_Backup. Try running same statement again if it works then you know what your problem is. Your problem is when you execute xp_cmdshell SQL automatically runs in SQL 2005 version instead of using DTExec.exe from SQL 2008 directory. If you don't have other BAT files running using DTExec.exe from 2005 then just leave it renamed and off you go. Otherwise you will have to make sure to convert all BAT file to start from SQL 2008 directories.

Hope this help...
sabarichandru
sabarichandru
SSC-Enthusiastic
SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)

Group: General Forum Members
Points: 174 Visits: 310
Hi everybody,
i'm also facing the same problem . i scheduled the job but its getting failure everyday . today i found the reason for failure i pasted the Error Message below . if anybody came across the same problem pls help me to resolve it .

TITLE: SSIS Execution Properties
------------------------------

Failed to open package file "D:\BI_AR\BI_AR\BI_AR.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.
({1192850D-1670-405C-BBC3-68431D4936FE})

------------------------------
ADDITIONAL INFORMATION:

Failed to open package file "D:\BI_AR\BI_AR\BI_AR.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.
({1192850D-1670-405C-BBC3-68431D4936FE})

Regards,
Sabarinathan
dkoester@cerner.com
dkoester@cerner.com
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 52
I was having the same\similar error and it turned out to be a mistake on my part.

So we have a SQL 2005 box that holds our SSIS. I had exported the files and opened them in Visual Studio 2008 to make changes. When I tried to reimport them I was getting the errors reports.

Resolution....
Reexport the SSIS, open and modify them in Visual Studio 2005, then everything worked.

This might not solve your problem, but it was the cause of mine.
Squatt Gmail
Squatt Gmail
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 258
I am receiving the same error (Error loading 'Package.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.) when attempting to either open my SSIS 2005 package in BIDS 2005 on my testing server.

My configuration: Windows Server 2003 Standard x64 SP 2 with SQL Server 2005 Standard SP2
What I tried:
1. Got C# code from MS Support that checks registry entries under CLSID for incorrect permissions - passed
2. Checked .Net version in DTEXEC.exe.config and installed on machine - same
3. Changed Run64BitRuntime to FALSE in Project Properties
4. Ran %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll and %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll" on server to ensure these were registered properly.

I am still unable to either load in VS or run from command line with DTEXEC utility. I have exactly the same configuration (well obviously not, but it appears to be) on my Production box and it works fine. We had to reload SQL Server a while back and I had to add SSIS on after the fact since my IT folks forgot that.

Please let me know if you need more information. This needs to be fixed as we run several DTSX packages on our test box before moving to Production and are unable to do so since the reinstall.

Thanks,

Scott
a_k93
a_k93
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 71
check the below url

http://sqlaj.wordpress.com/2010/01/12/t-sql-tuesday-002-a-puzzling-situation-the-package-failed-to-load-due-to-error-0xc0011008/
397229
397229
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 124
Hi All,
I am too getting this error all of a sudden. the package was working fine. it all started after I manually changed the config file!! the package was developed and tested thoroughly and was ready for UAT I was just trying to make it configurable Sad
Please help
----------------------------------------------------------------------------------------------------------------------
Error 1 Error loading 'pkg1.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. . C:\pkg1.dtsx 1 1
----------------------------------------------------------------------------------------------------------------------

Looks like ..some how I should be able to detach the pkg from Config file...but I am not getting any clue on how to do this!!

I also tried importing package in SQL server & adding the package to new solution..but no luck yet


Thanks in Advance

Rgds,
Sanjay
hubertp2 72207
hubertp2 72207
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 60
In testing this, I created a new VS 2008 project, which gave me access to its properties (right click on name). Found the debugging section and its 64 bit setting and changed it to false. This let me add the DTSX to my project. However, VS 2008 gave another error concerning the install of SQL Server. Seems it wants Integration Services running on the workstation where I was working. Tried the entire process on my SQL Server box (where IS is running) and it worked just fine.

End result, creating a new VS 2008 project on a box running IS and turning the project's debugging 64 bit setting to false let me add and modify the existing DTSX.
shawn.larson
shawn.larson
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 14
BSavoie (2/28/2010)
I solved this problem by going into Project Properties, Debugging, and setting Run64BitRuntime to false.

I expect since I'm running 64-bit OS, SSIS thinks it should run 64-bit DTExec, but I only have 32-bit SQL Server installed, so that's an incorrect assumption.

Hope this helps someone!


This worked for me, thanks!
Karan_W
Karan_W
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 135
could you tell me where to find Project Properties, Debugging and setting Run64BitRuntime to false.

I am getting the same error and also not able to open the SSIS package thruogh visial studio version.
Phil Parkin
Phil Parkin
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18921 Visits: 20460
anna-marie.barrington (8/4/2010)
Hello,

could you tell me where to find Project Properties, Debugging and setting Run64BitRuntime to false.

Thanks


It's in Visual Studio. While editing a package, select the 'Project' menu item and then select the [project] Properties item at the bottom of that menu.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search