• Check this if the package fails for the second time in the loop :

    I think you haven't specified the file to be picked by expression by using the value from For each loop and may be at the end of the package you are deleting your first file. So the second time, it's going into the loop it's failing.

    If it's failing for the first time it self, like others said make sure the package is in the right folder you have specified in the package. It's worth a check.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.