December 18, 2013 at 8:20 am
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
December 18, 2013 at 8:41 am
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
December 18, 2013 at 9:30 am
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
December 18, 2013 at 9:49 am
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
December 18, 2013 at 10:09 am
You might look at this thread: http://www.sqlservercentral.com/Forums/Topic737169-148-1.aspx#bm1420339
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply