"Error Loading <
Problem was due to the username set against the SQL Server Agent being different to the username used to designed the SSIS package. To resolve this we left the Package default protectionlevel to "EncryptSensitiveWithUserKey". When adding the SQL Server agent job we should set the protection level to be "Rely on Server Storage and roles for access control"
The following website was an excellent resource and help me understand the error:
http://www.mssqltips.com/sqlservertip/2091/securing-your-ssis-packages-using-package-protection-level/
No comments:
Post a Comment