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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » How to schedule ssis package to run only on...

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

Rate Topic

Display Mode

Topic Options

Author

Message

komal145

Posted Tuesday, November 27, 2012 1:46 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 1:38 PM
Points: 168, Visits: 540

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

Koen Verbeeck

Posted Wednesday, November 28, 2012 12:34 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 9,373, Visits: 6,470

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

komal145

Posted Thursday, November 29, 2012 1:48 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 1:38 PM
Points: 168, Visits: 540

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

« Prev Topic | Next Topic »

Permissions