I am using 2 task in control flow.
1st task is a "execute SQL task" which returning from DB into a variable called VAR1(i.e. VAR1 = C:\test_data\)
2nd task is "execute process task" where I wnat to delete all the files from the directory (i.e. value got in VAR1)
View Complete Post