I would like to execute a task in SSIS based on a condition. Specifically, I want to either create a table or clear it (truncate it), depending on if it already exists.
Currently I'm using a SQL task, where the SQL does the work, but I'm wondering if there is a better way...
Thanks!