So do I add an execute task for checking whoami or a dataflow task? I am sorry I haven't done this before so not sure how to check. I am...

Yes, the file gets picked up when I run the package from Visual Studio manually. 

 The files are placed in the folder on the shared network drive. I wrote...

Hi,

 I am back after forever . I am sorry I was pulled in another project. OK so I tried what you said.

I placed a file on...

Right, so I just checked and you are right, they both don't return the same name.

But how will this help? Does that mean that these are two different...

haa interesting, I can take a look at it. Thanks for your suggestion!!

I guess I have the files in the same system because we save files on the network\\directory \folder\files . For instance, if I load the file in my local directory...

oh ok got you!! I guess my question was how can I grant permissions for the whole service (SQL SERVICE AGENT SERVICE ACCOUNT)? But. . . 

Hi,

Thanks for your reply. I haven't hanged anything. Bu this morning I saved a test file in the "load file" folder I created and then I ran the job in...