I installed SQL Server Management Studio, to view some a SQL Server instance 2000.
I attempted to access the packages via the: "Management | Legacy | Data Tramsformation Services"
and got the following message:
SELECT permission denied on table sysdtspackages, database 'master', owner 'dbo'
I was perplexed, because when I attempted to view the DTS packages via SQL Server 2000 Enterprise Manager - I was to view tehm.
I got around the problem, via creating a new role called "DTS_user" and assigned
EXECUTE on sp_enum_dtspackages and sp_get_dtspackage in msdb.
I then went into the user and assigned that role.
Republished from http://www.sqlserver-dba.com.