Just in case anyone else was having the same problem I was encountering:

I was getting the same error while running an SSIS package that imports from an Excel spreadsheet on...

Hi,

I'm having a similar problem with the exact same error on a clustered config where the .xls file is local. Our set up is running full 64-bit (OS, processors,...

Thanks for the quick answer. You are correct. However, if you enter the IP of the cluster when installing SQL, you will receive a message telling you it's...

Actually, that's what caused this problem. Network personnel are not to have any access to SQL, and the DBAs are not to have any Windows access at all. ...

Doh! My bad. All of the packages come back with "Syntax error, permission violation, or other nonspecific error".

Also, the code for the first package that holds the parameter...

Good point Brandie, and that is most like our scenario now. Also Joe, I have run into problems with tasks/jobs etc in the past with this company because of...

Thanks for the replies. Joe, I can appreciate the scenario you outline in your response, but I don't believe we have reached that kind of size just yet. ...

Thanks for the prompt reply, Grasshopper! Yes please let me know of anything else you think of or if you happen to think of any other sources I could...