How to schedule ssis package to run only on Business working days ?

  • hi friends,

    I have a stored procedure (performing some transformations) , which is in SSIS package.I need to schedule SSIS package to run only on Business working days.

    How can I implement this?

    can anyone tell me please ?

    Thanks,

    Komal

  • You put it in a SQL Server Agent job and schedule the job. In the schedule, you can specify to run it weekly, and select the days Monday through Friday.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I was doing that , but I need to run only on Business working days.So I took calender table to run only on business working days.

    Thanks,

    Komal

  • Some where you need to maintain the holidays as well; With in your SSIS, run a SQL task and run your procedure only if it is not a holiday 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply