Ssis 864 [ 10000+ Ultimate ]

In the stored procedure, use local variables or OPTION (RECOMPILE) :

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

using (SqlCommand cmd = new SqlCommand(sql, conn)) In the stored procedure, use local variables or