Sunday, February 19, 2012

HELP: Connecting to a secure file share using DTS

I have a dts package that works in connecting to a secure file share when I run it manually. When I schedule it to run on its own - it fails due to the lack of a log on. Is there something I can do to initiate the log in via the schedule rather than me manually doing it ?

Thank you!

When you run it manually, it's executing under your security context. When you schedule it, it will run under the security context of SQL Server Agent service account if the job is owned by a sysadmin. You need to grant the SQL Agent service account permissions to the share. The following article explains this issue:

INF: How to Run a DTS Package as a Scheduled Job

http://support.microsoft.com/kb/269074

-Sue

No comments:

Post a Comment