Nice, we are making headway.
I am now receiving this error when debugging:
[Execute SQL Task] Error: Executing the query "IF EXISTS (SELECT * FROM sys.objects WHERE object_..." failed with the following error: "Incorrect syntax near 'Field1'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
-I don't have the variable stated anywhere else
-Tried deleting the middle Execute SQL Task
-Checkpoints are disabled
-Attachment 5 is the Execute SQL Task Properties
-Attachment 6 is the Package properties
Thanks.