Problem

When executing an SSIS package within a SQL Server job the following error can appear:

Source: Exec ?TASK_NAME? Description: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. 

 

Solution

Open the package in BIDS and go to the properties window of the corresponding task:

To solve this you must change the CommandTimeOut to 0 (for example). The default value is 30.

 

 


No feedback yet