Thanks for the answers guys!

I have only 1 Connection for all 20 sheets, assuming if there were 20 connections, the single Table would not be written to correctly.... Am I...

Thanks for the hints!

Where and what is maxdop? Where can I check that?

After a lot of studying the Execution Plans, I tried adding a clustered index  to the large (5 mil...

Thanks!

I did isolate the query-

and the Execution Plans are not the same!

What controls how an execution plan is put together? Why should it differ?

Would the Profiler tool be of help...

some new info on the problem:

I created a new SQL login with Sysadmin permissions

I changed the SQL Agent Connection login to this new login

I deleted the connection in the package...

Thanks Guys for the Answers!

I did indeed delete the connections and recreate them. The package runs manually until I close the package and reopen it- then the same old problem!!...

Thanks for the reply!

I am running them manually and via a Job. Same result.  what is the difference when you run them manually or not with respect to the access...