SSIS Jobs runs slowly in SQL 2008 server

Mar 20 2018 9:16 AM

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.

Answers (3)

Getting data from these 5 tables query