I have created an SSIS package in visual studio 2010 and deployed it at SQL server 2012 by using Integration Services Catalogs. When i run the package at BIDS the package runs succesfully without any problems. When i scheduled the SSIS package to run using a job the execution of the job fails 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
The job runs for 37 seconds and then fails.
Did You log anything? Did you take an trace?
What SSIS Elements you use?
Did the Account the Agent use to execute the Package all the needed rights?
Has the Account the correct drives mapped (if needed)
Did you use an User ODBC Datasource?
Another issue to mention is that because the job runs for a month now it does not fail all the time but at random intervals for example it may run succesfully from monday till thursday and then fails at friday.
Any clue what may be the cause of failure???
We expect the same, but have no solution for them. Its very sporadic. Sorry.