Just a few questions to help understand the problem:

Can you provide more information on what the DTS is doing, such as what is the source (file, SQL Server,...

Looks to me like you need to check your operating system permissions for that file. Are you able to open the file in any other way, such as...

The only permissions that I know of for DTS packages are those that are internal to the packages themselves (owner and user passwords), and permissions in the msdb database,...

I like topics like this. It gets me thinking. I would like to present a scenario where dynamic SQL is a better solution, as far as I can...