#temp is much more useful than @temp

Thank you for your reply.

The problem is this job should scheduled on 12th-20th business day. not a normal 12th-20th which means for every month these business days are gonna changed.

the problem I was facing was that month is not reset after the second loop run.

so month should be reset in the first loop before second loop starts.

While (@year <=...

Now I have a task deal with SSIS package which is must handle (if excel file is open by another user then stop the package and send an email &...