Thanks for the info. I did DBCC TraceOn (1800,-1) with no affect and see continued misaligned IO errors. Ideally, Id want our disk sectors matching at 512e or 4k, but...

bump on this issue.

What are your thoughts on something more like this was individual loops for each table to be deleted from:

DECLARE @DeleteDate DATETIME ,

@RowsToDelete BIGINT

-- Calculate the Min....

got it, and...

arnipetursson (3/11/2013)

---

Does RawVehicle have a one to one relationship to the other tables?

If if it is one to many, you will leave orphans in the other tables.

One way to do...

Lynn Pettis (3/11/2013)

---

If you are wanting to keep data for five days, you may want to revisit your date test. Looks to me that you will only keep data...

Agreed. I've even used the SMO Restore class to loop through a directory...

opc.three (7/29/2011)

---

zlthomps (7/29/2011)

---

Yes, it does - But I would ideally...

Yes, it does - But I would ideally be able...

Here is a shot of the failure, again without an error on the progress tab...

zlthomps (7/28/2011)

---

opc.three (7/28/2011)

---

Nice job posting your question 🙂

The only thing I can come up with for this, and it is a guess, is that there is only one copy of...

opc.three (7/28/2011)

---

Nice job posting your question 🙂

The only thing I can come up with for this, and it is a guess, is that there is only one copy of the...

oh nm, guess I posted too soon. I was using the following expression to build the connection string for the ADO connection:

"Data Source="+@TmpViewDBInstance+";Initial Catalog="+@TmpViewSourceDBName+";Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=SSIS-View_Staging-{000EBA5B-414B-447A-B0F6-D30043C11560}"+@TmpViewDBInstance+"."+@TmpViewSourceDBName+";Auto Translate=False;"

But this is a...

oh btw, I left out the lines where I close my connection and pass success to Dts.TaskResult...

TrgtDB.Close();

...

Thanks for the article, very good read.