• 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...