Hi,

We have created a ssis package to implement the incremental logic based on the start time of the server. When we execute this package through solution, the start time of the server is logged correctly. However when the package is executed through job the server time gets changed to end time of job execution.

Hence how to avoid this situation when executing through the job.

Hello Sainath -Can you please post the logic to get the server time which is used in SSIS? Based on that we can check for a clue.

What function do you use to get the server start time? Is that possible to look into error.log  or looking at create date of tempdb database?

Basically first we have written the logic where first we capture the source server start time and load mode =0 (bulk mode). Once the bulk mode is executed then the load mode=1(incremental mode). So the second time when the package is executed, its load mode=1 and the source server start time will be the time when the source server time was executed. This way it is working correctly when the package is executed using the visual studio.

However when the same package is executed through job, the time which gets logged after the execution is the end time of job and not the source server end time, which is why through job the package is failing.

Do you use SSIS system variable or T-SQL function for setting date values?

using variable for capturing date values.

Are you using the system variable System::StartTime ?

• Proposed as answer by Mike YinMicrosoft contingent staff, Moderator 3 hours 39 minutes ago

Hi Sainatth,

Can you try the System variable System::StartTime as Jonathan mentioned?

Regards,