MS SQL Server DTS - Issues autentification

Author

Issues autentification

Enric

2005-07-22, 3:24 am

Dear fellows,

I've got a DTS which create two plain files on a specified network path
using FSO object through a ActiveX task. AS usual that DTS is scheduled daily
and working properly but this morning failed. I was wondering why, due to
nothing has been changed.

Just a little bit of theory think is needed at least for me. Does anybody
know how works DTS when it's trying create a file in a network path??? I
mean, who's the responsible for that? DTS owner (in this case a NT user)
might be permissions on the aforementioned folder???

Any help will be welcomed.

Thanks in advance and regards,

Narayana Vyas Kondreddi

2005-07-22, 7:23 am

See if this article clarifies your doubt:
http://support.microsoft.com/defaul...;269074&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

"Enric" <Enric@discussions.microsoft.com> wrote in message
news:6A42A19D-D60E-4586-824B- CD6427B0CACA@microso
ft.com...
Dear fellows,

I've got a DTS which create two plain files on a specified network path
using FSO object through a ActiveX task. AS usual that DTS is scheduled
daily
and working properly but this morning failed. I was wondering why, due to
nothing has been changed.

Just a little bit of theory think is needed at least for me. Does anybody
know how works DTS when it's trying create a file in a network path??? I
mean, who's the responsible for that? DTS owner (in this case a NT user)
might be permissions on the aforementioned folder???

Any help will be welcomed.

Thanks in advance and regards,

Sponsored Links