I alwasy thought it would be running the DTS package as whoever was specified as the Job owner. So if this is sa then it may not have access to a ntework drive. Try using a newtork user as the owner of the job.
Did you have the full path (e.g. \\servername\folder\filename.txt) listed in the File Name of the Text Connection Properties? If not, try changing it to this format.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply