Hi All, Many times, we have to do this simple checking “if file exists/available .. then proceed” in SSIS operations. And Microsoft did not put any facilities to achieve this task in SSIS with default components. People also have raised this concern to Microsoft, but Microsoft explains that they have more priority works to deal with so this feature is not coming soon. you can check complete story here. Follow these steps: 1. Create a Boolean variable (I call it a Flag_Variable). Assign default value to “False“. 2. Use “Script Task” to check if file exists in given location. And … Continue reading →