SSIS Export to Excel - Drop Table/Delete From Issue

[kermitforney]

Trying to export from SQL into an Excel spreadsheet, but am getting an ISM error.

"[Execute SQL Task] Error: Executing the query "DELETE FROM `ItemForecastingExport$`
" failed with the following error: "Deleting data in a linked table is not supported by this ISAM.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

The SSIS Control Flow has two objects preparation SQL Task and the Data Flow Task.

Preparation (SQL Task):
EXCEL
DestinationConnectionExcel
Direct Input
DELETE FROM `ItemForecastingExport$`
GO

Data Flow:
Source Query -

SELECT strWarehouse
       ,Item#
       ,[Vendor Name]
       ,VendorID
       ,[Invoice Type]
       ,Category
       ,Description
       ,[I/D]
       ,[Item Status]
       ,Inventory
       ,[Weeks On-Hand]
       ,ShippedYTD
       ,[Avg. Shipped last 4 weeks]
       ,[Avg. last 4 weeks srvc %]
       ,[PO Back-Orders]
       ,FutureForecast1
       ,FutureForecast2
       ,FutureForecast3
       ,FutureForecast4
       ,FutureForecast5
       ,FutureForecast6
       ,FutureForecast7
       ,FutureForecast8
       ,FutureForecast9
       ,FutureForecast10
       ,FutureForecast11
       ,FutureForecast12
       ,FutureForecast13
       ,FutureForecast14
       ,FutureForecast15
       ,FutureForecast16
       
FROM tblItemForecastWeekly_ForecastReport

Destination Item Forecasting -
Points to the excel spreadsheet destination file


I have set the Run64BitRuntime to False, but am still receiving the message. Anyone have any insight?