September 1, 2005 at 10:06 am
Hi ,
I have created a DTS pacakge and scheduled it.The agent is running under a domain account having log on services rights.
Now when the job executes on the scheduled time it give error that the insert failed after 50000 record and my job failes . some time it gives error that user had not permission.
but when i run that job manually it runs fine.
can any one help me
thanx
killer
September 1, 2005 at 11:02 am
What are the source and destination in the package? Is one of them a flat file on a network share? If so, does the domain account that starts SQL Server agent have access to the share?
Greg
Greg
September 2, 2005 at 12:57 pm
Make sure you're using a UNC path to access the files when running the DTS package under your account instead of a mapped drive.
September 3, 2005 at 1:40 am
Hi ,
I am tranfering the data from Sqlserver to Text and Access Database.
I have log on permission.
from
killer
September 6, 2005 at 10:56 am
Make sure that the domain account that SQL Server Agent runs as has write permission for the shares where the text file and Access database are located.
Greg
September 6, 2005 at 9:04 pm
Hi,
I have all the permission and the sql agent start account has log on services permission
from
killer
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply