If you can create a Linked Server to Production, this works for me.

-- Pull Production Data over to Tmp Table

SELECT * INTO #Table1 FROM [Production Link Server].[Table1] WITH(NOLOCK)

SELECT * INTO...