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