Scheduling an SSIS package to run on specific days.
Hi! I need to schedule an SSIS job that runs weekly on Sunday night but for the last week it needs to run on that day either 30th or 31st. For example this month Aug 31 st is Monday so it should run on Monday instead of Sunday. Appreciate the help Thanks a lot.
If you can write a query that can check if any given day is a day that it should run, then you could try and create a job with no schedule to run your package. Every day, run the query that checks to see if this is a day the package should run. If so, start the job I mentioned above. If not, do nothing.