I created a linked server using a DTS package as the
datasource and I get the following error message when I
try to access information on this linked server:

Error: 7399: OLEDB provider 'DTSPackageDSO' reported an
error. Access denied. OLEDB error trace [OLE/DB
Provider 'DTSPackageDSO' IUnknown::QueryInterface returned
0x80070005: Access Denied.]

I created this DTS package using the following command:

sp_addlinkedserver
MyDTSPackage, 'DTSFilePackage', 'DTSPackageDSO', '/FC:\DTS\
DTSFilePackage.dts'

I am running MS SQL Server 2000 SP3.

I would greatly appreciate any help. Thanks.

Derek