Yes, the query needs the "INTO" which has already been communicated in one
of my previous posts.
Select top 0 *
from [base table]
is quite valid. If you want to be explicit, sure you can specify the column
list. However, if the schema is changed, for example, a non-null column
without default is added to the table, you would still have to change your
import code to accommodate this.
Your suggestion to create a #tmp would not fly for a 'bulk insert' process.
You have to use a permanent table or updatable view.
Preferably, I would create ...