Error Opening Data File Access is Denied

#1

I created a package to export data from one source and output as text file.
It worked successfully if the output text file is on this 1st PC as the SQL
Enterprise.
However, if I change the output text file to be on 2nd PC and I execute the
package , the error will come up.
I've mapped the target folder of the 2nd PC in the 1st PC and can view it
from 1st PC.
Has anyone done something similar and it worked ? Any advice is appreciated.
Thanks.

#2

forget to add that in the output (destination) 's properties, I specify \\ip
address\foldername\output.txt

"Jess" wrote:

Quote:

I created a package to export data from one source and output as text file.
It worked successfully if the output text file is on this 1st PC as the SQL
Enterprise.
However, if I change the output text file to be on 2nd PC and I execute the
package , the error will come up.
I've mapped the target folder of the 2nd PC in the 1st PC and can view it
from 1st PC.
Has anyone done something similar and it worked ? Any advice is appreciated.
Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Error Opening Data File Access is Denied

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Error Opening Data File Access is Denied - 01-18-2005 , 09:21 PM

RE: Error Opening Data File Access is Denied - 01-18-2005 , 09:31 PM