If you set up a linked server to the external file, that should work.

No. The only reason the "import/export wizard" "automatically" create the table is because in the underlying package it has "create table" tasks.

In the meantime, if you have lots of data,...

Is the job owner yourself? Try change it to NT AUTHORITY\SYSTEM, and that should fix the problem.

1-part name: dm_tran_locks

2-part: sys.dm_tran_locks

3-part: yourdb.sys.dm_tran_locks

4-part: yourinstance.yourdb.sys.dm_tran_locks

It seems to me that you are were doing an inner join of the two views, causing data for some person who has data in this view but no data...