Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an SSIS package that has been executing successfully for the last 7 years.

All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via End Task. I can access all of the databases but cannot run this package.
I believe one of our helpdesk admins may have messed something up when setting up the backup jobs on our backupexec server.

Can anyone give me some help as to what the cause could be? I have understood it to be a permissions error, but I am not clear where that could be.

share|improve this question

In the SSIS package, locate the Connection Manager for the DB you are trying to connect to. On the properties panel of that connection manager, set the 'Persist Connection' property to TRUE. This will maintain an active connection to the database server through the entire life of the package instead of only creating a connection for a specific task. It's a long shot, but worth a try.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.