• Tara-1044200 (7/11/2013)


    I am getting this error half way through the loop container in SSIS, why would it fail connection after certain point of successfull execution?

    Failed to acquire connection "server.DB". Connection may not be configured correctly or you may not have the right permissions on this connection.

    Hard to say. If the connection string is dynamic, check the permissions on the server. I'd also be checking permissions to underlying db objects for that point in the loop. When I've received this error message, it's usually because I forgot to take care of some permission--even when I thought all of the permissions were granted. I've learned through experience to take this message at it's word. :w00t: It's probably a permission issue.