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


ERROR opening SSIS Packages


ERROR opening SSIS Packages

Author
Message
syedathariqbal
syedathariqbal
SSC Veteran
SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)

Group: General Forum Members
Points: 227 Visits: 615
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
Attachments
Error Opening SSIS Package.JPG (18 views, 35.00 KB)
Lempster
Lempster
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3189 Visits: 1657
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
syedathariqbal
syedathariqbal
SSC Veteran
SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)

Group: General Forum Members
Points: 227 Visits: 615
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
Lempster
Lempster
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3189 Visits: 1657
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
Elliott Whitlow
Elliott Whitlow
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10046 Visits: 5314
You might look at this thread: http://www.sqlservercentral.com/Forums/Topic737169-148-1.aspx#bm1420339

CEWII
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