dbTalk Databases Forums  

SSIS Flat File Connection: Access is Denied

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


Discuss SSIS Flat File Connection: Access is Denied in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JJ of Eugene OR
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.