Thank you for your detailed response, you are a very big help as there is not a lot of useful/detailed information on this subject matter.

-I have the property expression set to "ForcedExecutionValue", Here is the code:

"IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID (N' "+ @[User::DestinationTable] +" ') AND type in (N'U'))

DROP TABLE "+ @[User::DestinationTable] +" (

[Field1][int][ IDENTITY(1,1) NOT NULL,

[Field2][int] NOT NULL )

GO

"

Here is the error message text copied from the progress tab:

[Execute SQL Task] Error: Executing the query ""IF EXISTS (SELECT * FROM sys.objects WHERE object..." failed with the following error: "Incorrect syntax near '+'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

-My ResultSet is 'None' as yours is.

Could this possibly be my parameter mapping? Attached is what I am currently working with, I have also tried it with no parameter mapping at all.

Thank you.