Ssis 864 !link! -

cmd.CommandTimeout = 300; // seconds cmd.ExecuteNonQuery();

using (SqlCommand cmd = new SqlCommand(sql, conn)) ssis 864

In the stored procedure, use local variables or OPTION (RECOMPILE) : cmd.CommandTimeout = 300