I did not know that Adam. Thanks for the info. I'll pass that on to my developers.

When you run the DTS job manually, it uses the security context of the current connection in Enterprise Manager.

However, when the job is scheduled, the security is different. It will...

Even if there is a way to do it, would you really want to go from one database link from another database link?

My first recommendation would be to install...

What you are looking for is:

select @@identity

I'm not real sure about the different security issues involved, but one issue that I had that forced me into using a domain user account was the ability to send...

Thank you very much for all your suggestions. It is very helpful.

At least I know I'm not crazy or blind. The jobs I create from the dts package (right-click -- create schedule) don't have that (run as user) dropdown box.

However, when I...

Thanks for everybody's ideas.

Linda, I think you are right on. I assume, then that the dts command encrypts the user and password within the command string. Knowing this fact, can...