Thank you both for your prickly, opinionated responses, which......uh.....were right on the money, and I followed your advice and solved the problem another way.

Thanks, sincerely.

BTW, the answer to my question...

Reason I want to use NoLock is because queries are returning slowly. Instructions say that is what it is good for.

This is on a reporting database, not a transactional...

I'll try. Thanks.

Lempster (5/23/2014)

---

I'm stating the obvious, but does the account under which SSIS is running have permission to access that file? Do you (or someone else) have the file open in...

On the Excel Connection manager itself.[/quote]

And what error does it give when SSIS ignores it?[/quote]

===================================

Package Validation Error (Package Validation Error)

===================================

Error at Load to Cache [Excel Source [1]]: SSIS Error Code...

Koen Verbeeck (5/22/2014)

---

nonghead-webspam (5/21/2014)

---

Ok, I went back to the ACE provider and things are working.

Turns out the problem was that the "Latest_File" variable needs an initial "feeder" value that will...

Ok, I went back to the ACE provider and things are working.

Turns out the problem was that the "Latest_File" variable needs an initial "feeder" value that will be replaced by...

Ok. I typed that in from a website that...

Well, I never really solved this.

Or maybe I did. It was not importing all the CSV rows because double quotes within the description field was throwing values into...

Not yet. I have to get both the...

Ok, partial solution.

The field was truncating because the Source Data Connection for XL had the field defined as 50 char. I guess it did that by default because...

Phil Parkin (5/16/2014)

---

You could also try saving the contents of the Excel file to CSV and importing that.

If it still fails, you'll know that you have to focus your investigations...

I tried using a ADO.Net destination instead, and it give the same result. I tried "ignore failure" on all columns.

I'm kinda stuck. If anyone has some suggestions on...

Warning: "Could not open global shared memory to communicat with performance DLL."

I get this on other things that run fine.

Phil Parkin (5/15/2014)

---

Try sorting the data in the Excel file differently and see whether it still bombs out at the same place. That should indicate whether it's data or a...