I created an SSIS package in Visual Studio 2008 and deployed it to SQL Server 2012 by using Integration Services Catalogs. When I run the package from BIDS it completes successfully. When I schedule the package to run using a job the execution of the job fails (sometime randomly) with the following message:
Environment reference Id: NULL. Description: Timeout expired. The
timeout period elapsed prior to completion of the operation or the
server is not responding. Source: .Net SqlClient Data Provider
I tried to add retry for this step and at second retry it works fine. I don't know the reason, this job worked for 2 years with no issues.
Best Answer
delete Unused Connection String(specially those have invalid connection string) search for child Package reference that are disable but has invalid references.