Thursday, 27 March 2014

SSIS DESTINATION ERROR :Timeout expired.ADO NET Destination [2206]

Post-1
How to Solve Error-ADO NET Destination [2206]

[ADO NET Destination [2206]] Error: An exception has occurred during data insertion, the message returned from the provider is: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Answer-  1. Right click on Ado.net Destination box and select property option. 

               



                2.  Select Command Timeout Property ,it consist default value 30           


                  3.  You can change  Command Timeout value 30 to 3000000(what you want )      



Finally your problem has been resolved 
Thanking you 
Have a Nice Day 
vipin singh
Date-28-03-2014
Posted by at

2 comments:

  1. Unknown27 March 2014 at 23:27

    This was quick and helpful. Thanks. :)

    ReplyDelete
  2. SkOffical28 May 2019 at 04:29

    You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. Managed IT Services Toronto

    ReplyDelete

Subscribe to: Post Comments (Atom)