Problem in SSIS package in DATA FLOW TASK section
I am placing the following command in a data flow task in an SSIS 2022 project, and the parameter I have is of type int(32) and the ReceptionDate_Shamsi column is of type char(10), and this causes my package to give an error. What is your solution?
SELECT
PatientReceptionHeaderPK,
PatientPK,
DoctorPK,
InsuranceTypeCode,
ReceptionDate_Shamsi
FROM PatientReceptionHeader
WHERE ReceptionDate_Shamsi >= FORMAT(DATEADD(DAY, ?,GETDATE()), 'yyyy/MM/dd', 'fa-IR')