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 #Table2 FROM [Production Link Server].[Table2] WITH(NOLOCK)
-- Drop any FK on tables if needed
-- Clean out Tables
TRUNCATE TABLE [Table1]
TRUNCATE TABLE [Table2]
-- Create any FK on tables if needed
-- Repopulate Table1
SET IDENTITY_INSERT [Table1] ON -- Use only if Table1 has Identity Column
INSERT INTO [Table1]
(Table1 Columns)
SELECT * FROM #Table1
SET IDENTITY_INSERT [Table1]OFF
-- Repopulate Table2
SET IDENTITY_INSERT [Table2] ON -- Use only if Table2 has Identity Column
INSERT INTO [Table2]
(Table2 Columns)
SELECT * FROM #Table2
SET IDENTITY_INSERT [Table2]OFF
-- Cleanup
DROP TABLE #Table1, #Table2