Problem in SSIS package in DATA FLOW TASK section
07:53 12 Dec 2025

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')
sql ssis powerbi business-intelligence dataflowtask