In addition to permissions: : select, insert, update, delete, exec SP only on CustomerDB1 and AdminDB, the "limited user" has to has also possibility to "TRUNCATE TABLE"

From...

I have implemented Export by using the Linked Servers and following SP:

'SELECT Top 100 ' + @id_field + ' INTO #tmp_table FROM ' + @src_table WITH (NOLOCK) ...