title: The timeout period elapsed prior to completion of the operation or the server is not responding. with showing package path
body: <p>I am uploading a mdb file from asp.net upload control into my sql server database. 
  When I am uploading file it is calling a stored procedure from my database in which  I m executing my SSIS packages. Whenever I am calling my stored procedure after few seconds I m getting the exception with showing the path of my packages.        </p>
  
  <blockquote>
    <p>$exception    {"Execution Timeout Expired.  The timeout period elapsed
    prior to completion of the operation or the server is not
    responding.\r\ndtexec /F
    \"C:\DTSX\DTSXPackage\DTSXPackage\Package.dtsx\""}    System.Data.SqlClient.SqlException</p>
  </blockquote>
  
  <p>As I read for solution. Read about Command timeout property of SQL. But still issue is same.
  When I m running stored procedure through SQL server it is running fine but when calling it through the asp.net code it giving exception.</p>
  
  <pre><code>stack  trace -
  
  &gt;       
  </code></pre>
  
  <blockquote>
    <p>StackTrace    "   at
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
    exception, Boolean breakConnection, Action<code>1 wrapCloseInAction)\r\n<br>
    at
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
    stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n<br>
    at
    System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject
    stateObj, UInt32 error)\r\n   at
    System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()\r\n 
    at
    System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()\r\n 
    at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()\r\n<br>
    at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte&amp;
    value)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior
    runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
    BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
    stateObj, Boolean&amp; dataReady)\r\n   at
    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
    RunBehavior runBehavior, String resetOptionsString, Boolean
    isInternal, Boolean forDescribeParameterEncryption)\r\n   at
    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
    async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry,
    SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n   at
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
    method, TaskCompletionSource</code>1 completion, Int32 timeout, Task&amp; task,
    Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)\r\n   at
    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource<code>1
    completion, String methodName, Boolean sendToPipe, Int32 timeout,
    Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)\r\n   at
    System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n   at
    System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query,
    QueryInfo queryInfo, IObjectReaderFactory factory, Object[]
    parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object
    lastResult)\r\n   at
    System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query,
    QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[]
    userArguments, ICompiledSubQuery[] subQueries)\r\n   at
    System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression
    query)\r\n   at System.Data.Linq.DataContext.ExecuteMethodCall(Object
    instance, MethodInfo methodInfo, Object[] parameters)\r\n   at
    DataAccessLayer.EspaceDatasetDataContext.ETL_IMPORT_09_01(Nullable</code>1
    userId, String clientMachineIP, String loadType, Nullable<code>1 instId,
    Nullable</code>1 bIsIgnoreErrors, Nullable`1&amp; rcout)</p>
  </blockquote>
  
  <p>stored procedure calling method:-</p>
  
  <pre><code>public int? RunDTSxProcess(long userID, string clientMachineIP, string loadType, long instID, bool ignoreErrors)
          {
              try
              {
                  int? result = 0;
                  var run = database.storedproc(userID, clientMachineIP, loadType, instID, ignoreErrors,ref result);
                  return result;
              }
              catch (Exception)
              {
  
                  throw;
              }
          }
  </code></pre>