How Do I set UserName and Password In DTS Package

[sqldevrequiretektips]

I have package name called XYZ which i have designed using DTS Designer, Now How Would i set username and password to secure my package...

Another words,,, If anyone try to open this package should get prompt to enter username and password and only valid username and password should allow to run DTS Pacakge....

Any help would really appriciate....

Thanks
AD

 

[dbomrrsm]

You should set up allowed users with a SQL Server account that will only allow them to access the server if they have a valid username and password.

[blue]DBomrrsm[/blue]

 

[sqldevrequiretektips]

Thanks, for your reply but....In my case...
I have three managers are going to use this DTS package and everybody else has user name and password for sql server...

so do u know is there anyway i can set user name and password prompt when my managers try to execute package....

Thanks

AD

 

[dbomrrsm]

how do they execute the package ?

[blue]DBomrrsm[/blue]