1. Based on your narrative, it is possible. Creating a specific location for
each month etc. seems an overkill but in general, it seems reasonable.

2. Yes, usually you can use global variables that can be changed or if it
depends on system date, you can change the logic accordingly. Some of the
ideas can be found here: http://www.sqldts.com/234.aspx

3. Yes you can. Each of the DTS executions can be set up as individual steps
within a job and can be set to do whatever actions depending on the success
and failures.

--
Anith