The solution of SSIS Error: Timeout expired.

SSIS error message is:

Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

 

Solution:

 

The solution is simple, change the CommandTimeout property of your SqlCommand object.

 The Connect Timeout attribute of a connection string determines how long a SqlConnection Object runs before it stops attempting to connect to a server.

 

For example:

Set OLE DB Destination.CommandTimeout = 0;

&

Set ADO.NET Connection.Connect Timeout = 0;

 

When 0 is for no limit.