Please describe the issue.

I've not tried importing an accdb before, so can't help with specifics.

But converting NVARCHAR to VARCHAR is straightforward enough – a Data Conversion component is what you need. This will...

Are you familiar with this stuff?

I've found it helpful, despite being a developer rather than a DBA.

I was wondering why mine...

Does the final SELECT take the same length of time, regardless of whether the rows are inserted or not? Just wondering whether the query is actually executing.

What is the source for this table?

What are the sources for the other tables?

Is there anything 'different' about either the source or the target for the problematic table?

("Different" = Different...

Note to OP: why make other people do searches for you, when it's...

Why not copy the entire DTSX file? What are you trying to achieve here?

Also, you need to be careful with the ID property, as they are supposed to be unique...

Agree with Thom. Redirect your errors from the target if you are having trouble tracking this down.

You need to do it all in a single query (which can include UNION ALL), but not using temp tables.

Not directly related to the question, but surely SMALLINT would have been a better datatype for PeriodYear?

A table lock is different from a deadlock. Which one do you mean?

If you want help with actual T-SQL, please take the time to post your data in a format which we can all consume (with CREATE TABLE DDL and INSERT ......

I created an expression for Argument and that worked

Good idea, well done.

Can you try the same thing, but using a file path which does not contain spaces?