25112
asked on
security for sensitive package moving from dev to dba
the ssis package - when we transfer to the dba, we keep the security on the package as 'do not store key/password' option. but there is a package we are working which involves more secure details and data (financial etc).. the dba has asked to provide proper security before putting in the network drive for them to pick up..
what security do you recommend? how would you do it if you were the programmer?
what security do you recommend? how would you do it if you were the programmer?
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi,
There're different ways and levels of security,
The most common will be "EncryptSensitiveWithPassw
Also check that link and it'll give you more information
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2548b905-c733-43c9-a6cc-fbfc27759d0c/
Regards,
Jason
There're different ways and levels of security,
The most common will be "EncryptSensitiveWithPassw
Also check that link and it'll give you more information
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2548b905-c733-43c9-a6cc-fbfc27759d0c/
Regards,
Jason
ASKER
OK- so EncryptAllWithPassword seems like best option- we can just give the password to next person in line who needs to open and use the package/solution.
if we need to schedule this job everyday (with the EncryptAllWithPassword protection) is there going to be a problem?
if we need to schedule this job everyday (with the EncryptAllWithPassword protection) is there going to be a problem?
Nope, no problem whatever.
If the package encryption level is EncryptSensitiveWithPasswo
from: http://msdn.microsoft.com/en-us/library/ms138023.aspx
If the package encryption level is EncryptSensitiveWithPasswo
from: http://msdn.microsoft.com/en-us/library/ms138023.aspx
ASKER
i could not see 'decryp' option in job properties.. is that where it is?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
v good - thanks all
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER