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