I've just installed a client version of SQL 2K on my machine to enable
connection to the server. I am able to connect to the databases via
enterprise manager. However, when I try to open up a new DTS package ...the
message "DTS Designer Error : Access Denied" pops up. I didn't encounter this
on my previous machine and I've tried all the suggestions given
(unregister/register the dll).

The other weird thing is if i use another ID to logon to this machine, DTS
has no errors. I've also registered all the users with full control in
Typelib.

Please help....thanks

I was having the same DTS Access Denied issue.

I finally figured out that it was caused by using runas.exe to start Enterprise Manager as a different (local, not domain) user. The local user account had the same permissions in SQL Server 2000, but that account did NOT have all the same permissions on the hard-drive. I am assuming whatever .dll is used by DTS Designer did not have permission to run.

By putting the local user account in the local Administrators group, everything worked fine. Security wise, that is a very bad idea, and I am still trying to find which .dll(s) are used so the local account can run them after it is removed from the Administrators group.

Kevin