this is my first post and I searched for a soluten but unfortunately couldn't find one.
I'm in the process of developing an ssis package that exports data into some text files that will be consumed by an other application. Creating the package and running it seems to be no problem.
I also managed to let the package being run by sql server agent on a schedule.
My problem is that the package (creating the files with the exported data) must run every month on the 3rd work day. This 3rd work day also depends on the holidays in that specific month. There is nothing as a work day I can select in sql server creating a schedule for a job.
Has anybody an idea how I can creata a custom schedule in sql server? Do I have to write an application that calls my package or sql agent job?
Thanks in adavence.