Hey @MartinSmith what about below logic as it is giving me same output SELECT * FROM DemoContact WHERE NOT PATINDEX('%[^01][^01][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9‌​]%',Contact)=0 AND Contact <> REPLICATE(LEFT(Contact,1),10) (DemoContact is a table which has contact column,)

Thanks @KirkSaunders for your valuble input.

Thanks @MartinSmith I have checked this and its working fine for me .

Thanks Jonathan , Can you please tell me that if we can use Script task to check the directory outside the For each loop and if it is true in that case only for each loop will trigger. if we check directory inside the loop then it will run the script task every time when we have more than one file.