You can chenge the Create Table tasks to pointing [YourDBProd].[dbo].[MyTable1], and in the Connection properties

change the MyDBTest to MyDBProd