Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to schedule ssis package to run only on Business working days ? Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 1:46 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 2:07 PM
Points: 171, Visits: 556
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
Post #1389404
Posted Wednesday, November 28, 2012 12:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
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.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1389541
Posted Thursday, November 29, 2012 1:48 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 2:07 PM
Points: 171, Visits: 556
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
Post #1390835
Posted Thursday, March 20, 2014 4:50 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 1:58 PM
Points: 164, Visits: 96
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
Post #1553279
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse