0

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"

3
  • What does your connection string look like? What components are you using to transfer the data? Is there a particular reason you're using the ado.net connection managers?
    – billinkc
    Apr 7, 2014 at 12:35
  • No but we know both are sql server db(cross db).
    – vivek
    Apr 7, 2014 at 13:55
  • with source we are using connection windows authentication but for destination we are using sql server authentication.
    – vivek
    Apr 7, 2014 at 13:59

1 Answer 1

-1
  1. configure your connection as xml

  2. set variable in connection

  3. set computer name & logic [Admin]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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