Ssis 864 Portable | Simple
using (SqlCommand cmd = new SqlCommand(sql, conn))
In the stored procedure, use local variables or OPTION (RECOMPILE) : ssis 864
cmd.CommandTimeout = 300; // seconds cmd.ExecuteNonQuery(); using (SqlCommand cmd = new SqlCommand(sql, conn)) In