Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ERROR opening SSIS Packages Expand / Collapse
Author
Message
Posted Wednesday, December 18, 2013 8:20 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:19 AM
Points: 108, Visits: 449
Hi All,

I am facing issues opening SSIS packages which I have taken from TFS. The error is attached and it says something like this..

"The package failed to load due to error 0xC0010014......." Complete error message is in screenshot.
I am using SQL Server 2008R2 and the same my team is using and they are able to open the packages. I am using a 32 bit OS ( WIndows XP)

I tried to set the the property Run64bitRunTime to FALSE (default its True), with no help leaving me frustrated since morning.

Any quick help ?

Thanks a lot for your time.
Regards
Athar


  Post Attachments 
Error Opening SSIS Package.JPG (10 views, 35.94 KB)
Post #1524165
Posted Wednesday, December 18, 2013 8:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:35 AM
Points: 2,126, Visits: 1,473
Hi,

What is the ProtectionLevel of the SSIS package set to? If it is 'Protect All With User Key' then only the User who created the package will be able to open it and run it. (I am assuming that you are not being prompted for a password as the correct action to take in that case is obvious - supply the password!).

for more information about SSIS package protection and security, view the link below:

http://technet.microsoft.com/en-us/library/ms141747.aspx

Regards
Lempster
Post #1524181
Posted Wednesday, December 18, 2013 9:30 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:19 AM
Points: 108, Visits: 449
Hi,

I have the password of the package and I am using the correct password to open it (trying to open it, I mean)

Athar
Post #1524204
Posted Wednesday, December 18, 2013 9:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:35 AM
Points: 2,126, Visits: 1,473
Hmm. Ok, does the package have any Package Configurations active, e.g. stored in an XML file or database table? If so, have you checked that you have the necessary permissions to access the file/table?

Try getting one of your colleagues (for whom the package is opening successfully) to log in on your PC and try opening the package. If that works then the problem is with your User Account.

Regards
Lempster
Post #1524213
Posted Wednesday, December 18, 2013 10:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
You might look at this thread: http://www.sqlservercentral.com/Forums/Topic737169-148-1.aspx#bm1420339

CEWII
Post #1524222
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse