Hi all,
Recently we have upgraded our windows server 2005 to windows server 2008 with SQL server 2008.
In the past SQL server 2005, The ssis jobs were running within 5 seconds to complete the job.
But after upgraded the packages to 2008 server , these ssis jobs are taking more than 10 minutes to complete the job
Kindly let us know, how to resoleve this performance issue.