June 1, 2004 at 1:41 pm
I'm hoping someone can help me out here. I created a DTS package that pulls data from DB to another. The DTS package works fine, but when I schedule to DTS package to run as a job, the job fails. Maybe I'm just looking in the wrong place but the error log just tells me what step was the last one to run. It's not really telling me what happened. Is there another place I should be looking for error logs? Does anyone know why this may be happening?
June 1, 2004 at 1:48 pm
What is the error from the log?
Check the logins that you use to connect to the two databases, if you are using windows authentication check that the sql server agent service account has sufficient permissions to be able to access both.
June 1, 2004 at 1:58 pm
I turned on the output file in the job and it gave me what I needed to see. Turns out I needed to use a different method for defining that path to the file (\\server\share). I would have thought it would have worked with just defining what drive I needed to access.
I'm just glad I got it work. It's been bugging me for a few days now.
June 2, 2004 at 12:43 pm
Wireless guy,
What method did you use to define \\server\share ? I've been having major problems with this, even when mapping a drive to it.
Signature is NULL
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply