SET @aryTableNames = 'thisTable','thatTable','anotherTable'

DO
	SELECT * INTO [Server].[dbo].[@aryTableNames]
	FROM OPENQUERY(mysqlDB, 'SELECT * FROM `@aryTableNames`')
LOOP

DECLARE @TableNames TABLE ( TableName VARCHAR(30) )

INSERT @TableNames ( TableName )
SELECT 'thisTable' UNION
SELECT 'thatTable' UNION
SELECT 'anotherTable'

DECLARE @sql VARCHAR(100), @Table VARCHAR(30)

WHILE EXISTS ( SELECT TOP 1 * FROM @TableNames )
BEGIN

SELECT @Table = ( SELECT TOP 1 TableName FROM @TableNames )
DELETE FROM @TableNames WHERE TableName = @Table
SELECT @sql = 'SELECT * FROM ['+@Table+']'
EXEC(@sql)

END

DECLARE @TableNames TABLE ( TableName VARCHAR(30) )

INSERT @TableNames ( TableName )
	SELECT 'thisTable' UNION
	SELECT 'thatTable' UNION
	SELECT 'anotherTable'

DECLARE @sql VARCHAR(200), @Table VARCHAR(30)

WHILE EXISTS ( SELECT TOP 1 * FROM @TableNames )
	BEGIN
		SELECT @Table = ( SELECT TOP 1 TableName FROM @TableNames )
		DELETE FROM @TableNames WHERE TableName = @Table
		SELECT @sql = 'IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE id = object_id(N''[dbo].[' + @Table + ']''' + ') AND OBJECTPROPERTY(id, N''IsUserTable'') = 1)' +
			' DROP TABLE [dbo].[' + @Table + ']'
		EXEC(@sql)
		SELECT @sql = 'SELECT * INTO [dbName].[dbo].[' + @Table + '] ' +
			'FROM OPENQUERY(mysqlDB, ''SELECT * FROM `' + @Table + '`'')' 
		EXEC(@sql)
	END