Thread: DTS import works directly, fails when scheduled
View Single Post
  #15 (permalink)  
Old 06-06-06, 14:10
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
  
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
That's exactly what I was looking for...

I had presumed that you were using a UNC from the beginning, so I never thought to question that. I thought the problem you were having was due to the job starting as either a SQL login or a Windows login that didn't have permission to read from that UNC.

What I wanted (and you gave in post 14) was an explanation of what actually worked for you.

Thanks!

-PatP
Reply With Quote