Can you password protect data in DTS?

• JimReeves71

  Default port

  Points: 1410

  More actions

  April 13, 2011 at 4:20 am

  #248855

  We are using DTS on a SQL Server 2000 server, to import data.

  We are aware that there are 2 types of password in DTS, Owner and User.

  Do these protect the data that is being imported...or they just apply to the Editing or Running of the package?

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  April 29, 2011 at 8:54 am

  #1317826

  DTS package passwords protect the package, not any data that the package may process.

  Greg