tags:

views:

29

answers:

2
Q: 

SSIS: Is it possible setting a password for a ssis package just like we did for dts legacy packages?

Is it possible setting a password for a ssis package just like we did for dts lagacy packages? I've created a new ssis package but do not know how to set a password for it?

+2  A: 

Yes you can. It's called the package ProtectionLevel. By default, it's set to encrypt only sensitive information so that only your account can read/use it. But you can change it to use a password.

Todd McDermid  2010-07-12 16:22:58
+1  A: 

Your better off using package configurations, that way it is easier to configure any changes for a test environment. We store all our connection details in these configuration files and have two sets - one for test, one for production.

Mr Shoubs  2010-07-14 12:26:39

related questions

What are some good security questions?
What's a good alternative to security questions?
Protect embedded password
How do you generate passwords?
Should I impose a maximum length on passwords?
How best to generate a random string in Ruby
What is the best way to check the strength of a password?
In a client-server application: How to send to the DB the user's application password?
How does your company manage credentials?
Replacing plain text password for app
How to implement password protection for individual files?
Password generation, best practice
Unique key generation
Generating Random Passwords
Oracle lost sysdba password
How does one decrypt a PDF with an owner password, but no user password?
Storing Windows passwords.
How do I avoid having the database password stored in plaintext in sourcecode?
How do I write Firefox add-on that automatically enters proxy passwords?
How to store passwords in Winforms application?
Two-way password encryption without ssl
Disable browser 'Save Password' functionality
Simple password encryption
Best way to store a database password in a startup script / config file?
Encrypting Passwords