• You mentioned a temporary table.

    When SSIS starts evaluating your package, the temporary table doesn't exist yet.

    Hence, he will find a reference to an object that he cannot find.

    Solution: you must set the property DelayValidation of all components/tasks that use this temporary table to True.

    See if that helps.

    Regards

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP