I have run into a strange problem and hoping someone may have a suggestion.
We have a set of SSIS packages that are developed in BIDS 2005. The packages are all executed by SQL Agent Jobs on a scheduled basis. These packages have been running on numerous SQL 2005 instances for the last year or so with no issues being experienced.
We recently has our first customer start running SQL 2008 R2 and we have internally upgraded to SQL 2008 R2 in our development environment. We are not converting the packages to SQL 2008 as we still need to support customers who are running SQL 2005. The
problem is that in both our dev environment and at this particular customer, we have seem a random issue where the SQL Agent job never seems to end. Most of our jobs normally execute in less than 2 minutes, but occasionally (one or twice a week) a random job
will just not end until we manually cancel it. We don't know if it is the SSIS package that is not ending or the SQL job.
We never experienced this on SQL 2005.
Anyone have any ideas what may be causing this? Any suggestions for troubleshooting?
Any help will be much appreciated
Craig Bryden - Please mark correct answers
View Complete Post