July 28, 2005 at 6:02 am
Hi,
I have a problem when i schedule a DTS package... I can execute the package manually but once i schedule the package it fails to execute..
Can someone please help me.
July 28, 2005 at 9:06 pm
Hi Saadiq,
U did not mentioned about the error. as per my knowledge ur SQL Server agent is stoped.
from
killer
July 28, 2005 at 9:46 pm
The error is important (expand the job step history to see the exact error). Keep in mind that when you execute it, it executes on your computer under your user account. However, when it is scheduled, it executes on the SQL Server under the SQL Server Agent service account.
As to usual causes of failure:
So if you've got a reference to a drive letter in the DTS package that refers to a network location (say like F:\ mapped to a network share), that's usually one reason for a failure. Then you've got to use the network path as an UNC (\\Server\Share).
Another typical issue is the service account for SQL Server Agent doesn't have permissions to access files, etc.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply