• I have deployed the package in my local file system and the file does exist.

    Also the filename is stored in a variable and evaluated as expression:

    Variable name Expression

    DEST_FILE : "C:\\IPC_" +Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) + Right("0" + (DT_STR,4,1252)

    DatePart("d",getdate()),2) +(DT_STR,4,1252) DatePart("yyyy",getdate()) + ".txt"

    Even if the file doesn't exist it should create it dynamically. Please correct me if I am wrong.

    And I have given the permission to the proxy account that runs this SSIS package as Job.

    But even then I am getting the error.