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 yourSqlCommand object.

?The Connect Timeout attribute of a connection string determines how long aSqlConnection 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.