Dear Sir, I am facing below problem for last 1 week, i have not found any proper solution for same.suppose I am having 3 excel connection ,each excel have different data flow task. My ETL Process load daily by daily. after loading data from excel to sql table I am deleting the file to avoid duplicate entry next day. in some dataflowtask will not get excel file some day due to that my package is failing My aim is , if DFT1 does not find file then it should go to next DFT2 without failing Please suggest the best way with example as this is very important for me Regards, Vipin jhaThankx & regards, Vipin jha MCP

add a loop and add each DFT in that loop, check this link as a close sample but remember that you have to place a DFT insted of a SCR task anyways you will have step 1- Use a SSIS variable as a Flag = False step 2- LOOP 1 --> DFT 1 --> SET Flag to TRUE in a Script task ---> End Loop 1 step 3- connected to ......(green Line) Constrain IF Flag = TRUE step 4- SCRIPTTASKset flag = False step 5- LOOP 2 --> DFT 2 --> SET Flag to TRUE in a Script task --> End Loop 2 step 6- connected to ......(green Line) Constrain IF Flag = TRUE step 7- SCRIPTTASKset flag = False step 8- LOOP 3 --> DFT 3 --> End Loop 3 step 9- Move file/Delete file what it does it loops through the folder that is related to DFT 1 and pick ups the file and sets the SSIS variable to TRUE in the script then once the loop finishes it goes to check if that the FLAG = TRUE in the constrain , IF not it will stop but if the flag = TRUE , it will go to the next step and set the flag to FALSE and move on for the next Loop (Loop2) and so on... goodluck Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).