Q: SSIS Package, execute every 13 hours for previous 12 hours of data I have a SSIS Package and I need to schedule it to run at 1:00 AM and 1:00 PM every day.
At 1:00 AM it should pass parameters of the previous day for e.g. 
15 Nov 2018 12:00 PM as @StartDate & 15 Nov 2018 11:59 PM as @EndDate
At 1:00 PM it should pass parameters of the current day for e.g. 
15 Nov 12:00 AM as @StartDate & 15 Nov 11:59 AM  as @EndDate
A stored procedure is called through an OLE DB Source Editor task in Data Flow. 
Does anyone have any suggestions that How I could achieve this noting the fact that if the job fails at 1:00 PM  & it should re-run at 2:00 PM, it should still pass the same parameters. 

A: Here are the steps to pass the date parameters to OLEDB task.


*

*Have start date & end date parameters in (I suppose you must be having).

*Assign the dates values to both parameters using SQL task.

*Pass these parameters to OLDEB stored procedure to data flow task.


For scheduling:
Create two different jobs for each run, one for 1 AM & another for 2 AM of the job.
For second job run, implement the following steps.


*

*Create a table which log the job execution status with date and time. That table has insertion after each run of the job. 

*When second job schedule execute first check log table in first step and check the last run status of the job.

*If it was successful exit else go to next step.
Hope this will help. 
