This is an extension to the below posthttp://visakhm.blogspot.in/2012/05/package-to-implement-daily-processing.htmlwhere I explained the usage of looping logic in SSIS to do automated file processing on daily basis. One of the common issues we face in above scenario is ability to handle error…
Retrieve latest weekday date from a given date
Recently for one of my projects there was a requirement to get the latest Tuesday from a date value. I had used the below logic for the requirement. I’m converting it to a UDF and posting it here so that…