Hi, The ssis package takes 5 seconds to complete when run from the designer. This ssis package is now triggered from within a scheduled job which takes 30 seconds to complete. I do not see why there is a difference of 25 seconds. Any thoughts please? Thanks
What kind of job is it? Perhaps you are running it from designer just after it has completed as a scheduled job, and there is no more data to be processed? Something like that.
I created a job in sql server 2005 which runs that ssis package. Trying to find out why this job takes longer to complete than when the ssis package is run from the designer i.e by clicking the run button. Thanks
We already knew that. What does the ssis package actually do? If you run the job from Designer just before the scheduled job will start, does it take longer?