SSIS Truncate Microsoft Access table using Execute SQL Task
You can use Execute SQL Task to query a Microsoft Access Database, but you cannot use a Truncate command since it is not supported, you have to use a DELETE FROM ... command. The following screenshots show an example of the OLE DB Connection manager, and the Execute SQL Task configuration: Original post: https://stackoverflow.com/questions/58306930/ssis-access-database-need-to-empty-table-on-my-destination-access-database-tab/58348096#58348096