DTS Authentication

#1

I have a DTS package with 2 steps, step 1 is executing a SP using SQL login
and step2 copying a text file to another server.

The user who will be executing the DTS has only SQL login.

I need to execute step 2 using a domain account (Windows Authentication) in
order to be able to copy the file to another server, like using Run as so I
can pass a domain account and password.

Is there any way in DTS that I can do that?

Thanks

Ayad

#2

your sql server account should have awrite access on destination server you
want to copy the file

"Ayad" <ashammout1 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package with 2 steps, step 1 is executing a SP using SQL login
and step2 copying a text file to another server.

The user who will be executing the DTS has only SQL login.

I need to execute step 2 using a domain account (Windows Authentication)
in
order to be able to copy the file to another server, like using Run as so
I
can pass a domain account and password.

Is there any way in DTS that I can do that?

Thanks

Ayad

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Authentication

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Authentication - 11-03-2004 , 08:51 AM

Re: DTS Authentication - 11-04-2004 , 12:13 PM