I have a DTS Package, that runs just fine, when executed interactively. HOWEVER, When I schedule the pkg to run as SQL Job, it errors out.
So, I tried to go to the SQL JOb STEP-Advanced tab, and looking for the 'Run as User'. however, that option 'Run asUser' does not show up- Is this becahse the job is calling a dtspcakge, using the Operating sys commend Exec...
My questions is WHY Do I NOT SEE THE' RUN AS USER ' Option, in my Step of the SQL JOb?
When scheduled to execute via SQL Agent, DTS packages will run under the security context of the account under which the SQL Agent service is running. For this reason you'll need to assign permissions on any external resources, as appropriate, to this account.
Chris
