I kept getting a syntax error with my Execute SQL Task:

DROP TABLE 'contacts'

GO

Finally I removed the single quotes and it worked:

DROP TABLE contacts

GO

weird...