ssis ado.net destination has failed to acquire the connection I am Transferring data from sql server source db to sql server destination db (cross db).
but some times getting error "ssis ado.net destination has failed to acquire the connection.The connection may have been corrupted"
configure your connection as xml 
set variable in connection 
set computer name &amp; logic [Admin]