Post reply

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

  • November 27, 2012 at 1:46 pm

    #270700

    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

  • November 28, 2012 at 12:34 am

    #1562946

    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

  • November 29, 2012 at 1:48 pm

    #1564027

    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

  • March 20, 2014 at 4:50 pm

    #1698917

    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