Hi,
I am able to execute a DTS package from a stored procedure just fine using
the login credentials from SQL Server. How can I, in the stored procedure,
change the identity to that of a WINDOWS LOGIN TO EXECUTE THE DTS PACKAGE?.
You see, I am using the MSMQ in DTS, but, my queue is on a remote server and
when I execute the package using the SQL login I get the "Access Denied"
error. The sp is executed by a trigger.

Please advice.

One possibility is calling the dtsrun.exe application via the "runas"
command. Unfortunately, this command always prompts for the Windows password,
it cannot be scripted. One solution is to use the DOS application "lsrunas".
Use dynamic sql and a call-out to the DOS shell (e.g. exec
xp_cmdshell('lsrunas ... dtsrun... <package>'). Something like that.

Search for it on Google, it is a little hard to find. It does the same, but
the password can be supplied via a parameter.

Two things: 1) hardcoding a windows password is not recommended. 2) You have
to be able to put the lsrunas.exe program somewhere on disk.