Click here to Skip to main content
14,494,682 members
   

Database

 
QuestionCode Expert Pin
Keith@Stand7-Jun-18 8:13
MemberKeith@Stand7-Jun-18 8:13 
AnswerRe: Code Expert Pin
OriginalGriff7-Jun-18 8:16
mveOriginalGriff7-Jun-18 8:16 
AnswerRe: Code Expert Pin
Swinkaran7-Jun-18 18:39
professionalSwinkaran7-Jun-18 18:39 
GeneralRe: Code Expert Pin
Keith@Stand7-Jun-18 19:18
MemberKeith@Stand7-Jun-18 19:18 
GeneralRe: Code Expert Pin
Mycroft Holmes17-Jun-18 20:51
professionalMycroft Holmes17-Jun-18 20:51 
GeneralRe: Code Expert Pin
jschell23-Jun-18 5:21
Memberjschell23-Jun-18 5:21 
AnswerRe: Code Expert Pin
Christopher Stewart27-Jun-18 10:47
MemberChristopher Stewart27-Jun-18 10:47 
QuestionRunning the Package in different versions of SQL Server Pin
indian1434-Jun-18 10:34
Memberindian1434-Jun-18 10:34 
Hi,

I have SQL Server 2012 on my machine, I have developed an SSIS Package that I could able to run on locally in debug environment and deployed on SQL Server 2012 Server as well. But the Test and Staging Servers are 2008 R2, when I tried to deploy the Package on the 2008 R2 servers I am getting the following error, any help would be greatly helpful, thanks in advance.
<h2>TITLE: Import Package</h2>

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.

<hr />

ADDITIONAL INFORMATION:

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.

<hr />

BUTTONS:

<h2>OK</h2>

..==================================

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.


And when I queried to see the actual error of the Job I am getting following error message:
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility  Version 11.0.6020.0 for 64-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  2:11:14 PM  Error: 2018-06-04 14:11:14.23     Code: 0xC0011007     Source: {12A3883D-DB4A-4085-A76A-DFB45C939490}      Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.  End Error  Error: 2018-06-04 14:11:14.23     Code: 0xC0011002     Source: {12A3883D-DB4A-4085-A76A-DFB45C939490}      Description: Failed to open package file "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" due to error 0x80070005 "Access is denied.".  This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format.  End Error  Could not load package "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" because of error 0xC0011002.  Description: Failed to open package file "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" due to error 0x80070005 "Access is denied.".  This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format.  Source: {12A3883D-DB4A-4085-A76A-DFB45C939490}  Started:  2:11:14 PM  Finished: 2:11:14 PM  Elapsed:  0.125 seconds.  The package could not be found.  The step failed.
The job failed.  The Job was invoked by User DHSINTRA\SSubrama.  The last step to run was step 1 (OPSExtract).

Any help would be very great, thanks in advance buddies - thanks a lot.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

-- modified 4-Jun-18 18:23pm.
AnswerRe: Running the Package in different versions of SQL Server Pin
Mycroft Holmes4-Jun-18 14:10
professionalMycroft Holmes4-Jun-18 14:10 
Questiontrying to follow this tutorial but video not set at 100% Pin
piano00112-Jun-18 18:14
Memberpiano00112-Jun-18 18:14 
AnswerRe: trying to follow this tutorial but video not set at 100% Pin
OriginalGriff2-Jun-18 18:48
mveOriginalGriff2-Jun-18 18:48 
AnswerRe: trying to follow this tutorial but video not set at 100% Pin
Mycroft Holmes2-Jun-18 22:48
professionalMycroft Holmes2-Jun-18 22:48 
AnswerRe: trying to follow this tutorial but video not set at 100% Pin
CHill607-Jun-18 2:10
mveCHill607-Jun-18 2:10 
Questionhow to use implode and explode Pin
piano00112-Jun-18 16:55
Memberpiano00112-Jun-18 16:55 
AnswerRe: how to use implode and explode Pin
Eddy Vluggen4-Jun-18 0:37
professionalEddy Vluggen4-Jun-18 0:37 
AnswerRe: how to use implode and explode Pin
phan anh huan13-Jun-18 5:43
Memberphan anh huan13-Jun-18 5:43 
QuestionCan't get my 2nd table working Pin
piano00112-Jun-18 2:06
Memberpiano00112-Jun-18 2:06 
QuestionRe: Can't get my 2nd table working Pin
Richard MacCutchan2-Jun-18 2:46
mveRichard MacCutchan2-Jun-18 2:46 
AnswerRe: Can't get my 2nd table working Pin
piano00112-Jun-18 4:33
Memberpiano00112-Jun-18 4:33 
AnswerRe: Can't get my 2nd table working Pin
piano00112-Jun-18 18:39
Memberpiano00112-Jun-18 18:39 
GeneralRe: Can't get my 2nd table working Pin
Richard MacCutchan2-Jun-18 21:08
mveRichard MacCutchan2-Jun-18 21:08 
GeneralRe: Can't get my 2nd table working Pin
piano00112-Jun-18 21:27
Memberpiano00112-Jun-18 21:27 
GeneralRe: Can't get my 2nd table working Pin
Richard MacCutchan2-Jun-18 21:35
mveRichard MacCutchan2-Jun-18 21:35 
GeneralRe: Can't get my 2nd table working Pin
piano00112-Jun-18 22:27
Memberpiano00112-Jun-18 22:27 
AnswerRe: Can't get my 2nd table working Pin
piano00112-Jun-18 15:43
Memberpiano00112-Jun-18 15:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.