Run SSIS package in two different schedule

I have 2 data flows inside my package, I wanted to run the first data flow step in the morning and the other data flow step in the evening. is this possible?
LVL 15
Faiga DiegelSr Database EngineerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
uhh.. errmmm....

You can't run only a subset of an SSIS package, unless you have code that determines what to execute, what not to execute.
Perhaps you can schedule your SSIS package using SQL Agent / ActiveBatch / Whatever, where the job passes a parameter that means one thing for the am job, and nother for the pm job.
0
 
randy_knightCommented:
Why not just have 2 separate packages?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.