dbTalk Databases Forums  

Making DTS Packages Password Protected

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Making DTS Packages Password Protected in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sshaahin
 
Posts: n/a

Default Making DTS Packages Password Protected - 08-18-2005 , 02:21 PM






We would like to assign owner and user passwords to all of our existing DTS
packages, short of having to open each package and Save As a new package,
which will cause a new package ID to be assigned to the package. Is there a
script that would allow us to insert password into the existing packages?

Thank you in advance.

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Making DTS Packages Password Protected - 08-18-2005 , 02:28 PM






Unfortunately not.

If the regeneration of a version number is problematic for you then why not
remove that requirement?

"sshaahin" <sshaahin (AT) discussions (DOT) microsoft.com> wrote

Quote:
We would like to assign owner and user passwords to all of our existing
DTS
packages, short of having to open each package and Save As a new package,
which will cause a new package ID to be assigned to the package. Is there
a
script that would allow us to insert password into the existing packages?

Thank you in advance.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.