09/13/12
ADO.NET Connection Timeout expiredProblem 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.
Tags: timeout expired
No feedback yet |
|