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"
-
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?– billinkcApr 7, 2014 at 12:35
-
No but we know both are sql server db(cross db).– vivekApr 7, 2014 at 13:55
-
with source we are using connection windows authentication but for destination we are using sql server authentication.– vivekApr 7, 2014 at 13:59
Add a comment
|
1 Answer
configure your connection as xml
set variable in connection
- set computer name & logic [Admin]