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