We run SSIS packages in SQL Agent jobs. Since we have a separation of duties between development and database administration different people will develop the SSIS packages and setup the job in SQL Server. Depending on the Protection Level setup in the SSIS package we started getting the eror below.
DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".
The link below has an excellent discussion of the problems and differences with the different options available. Having permission errors, have a look at the link below...
http://bi-polar23.blogspot.com/2009/04/ssis-and-package-protectionlevel.html
No comments:
Post a Comment