Having issues with ssis workflow to extract data from SQL Server to an Excel destination

Kindly assists, I am an amateur, I am trying to extract data from our SQL Server database using OLEDB source to an Excel destination.

I am getting this error shown below. My inherited query has a temporary table in it syntax , and secondly a declared variable.

I actually inherited this from a predecessor who left without putting me through what does what.

Thank you.

Please explanation in a layman man language will be greatly appreciated

Error:

TITLE: Microsoft Visual Studio

Exception from HRESULT: 0xC0202009

Error at Data Flow Task [OLE DB Source 2]: SSIS Error Code DTS_E_OLEDBERROR. > An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "Must declare the scalar variable "@DATE1".".

BUTTONS:

OK