SSIS Flat File Connection: Access is Denied -
04-03-2006
, 06:20 PM
Generous and Kind Database Community:
I am running a very simple SSIS package that includes bulk loading data from
an .txt file. Of course, I am using a flat file connection. I am getting
the following error:
"Cannot bulk load because the file "\\clsrv111\BlaBlaBla\ZipCode.txt"
could not be opened. Operating system error code 5(Access is denied.).".
I've tried various options including UNC and using the named letter for the
drive where the .txt file is located. Here's the thing: If I run the package
while I am connected to our database server remotely (in other words, if I
basically log onto the database server and run the SSIS package from there),
everything works just fine. But it is my strong preference to be able to run
the client software (BIDS) from my own laptop and just connect to the
database server as need-be. It is when I run the package from my laptop that
I get the above error.
It's got to be some kind of permissions thing, right? Any ideas? Thank you
very much!
- JJ, Eugene Oregon
PS: It seemed OK to post about SSIS in this DTS group. If this is not the
right place for this question, I'd appreciate a hint on where to go. I
didn't see an SSIS group. Thanks again. |