Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.