I am running a stored proc from EXEC in a ado.net source and getting the following error: "[ADO NET Source ] Error: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
The actual procedure runs for 40 seconds in SSMS. I have tried resetting the Command Timeout, but if it were at 0 anyway, why would I need to mess with it? Is there somewhere else I should be looking or something I need to change? I have other stored procs for other SSIS jobs that are running fine. I also tried changing to OLEDB and get the same.