Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Run SSIS package in two different schedule

Posted on 2008-10-08
2
Medium Priority
?
387 Views
Last Modified: 2013-11-10
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?
0
Comment
Question by:Faiga Diegel
2 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 1500 total points
ID: 22670986
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
 
LVL 4

Expert Comment

by:randy_knight
ID: 22675562
Why not just have 2 separate packages?
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question