Thanks all! I got it working.

Hmmm, the installer says I have a higher version already installed on...

Thanks, got it working...

GSquared (6/28/2011)

---

Tables that you will Output Into cannot have foreign key constraints, nor can they be referenced by foreign key constraints. There are other rules as well. The...

Here's the script I'm trying to run that throws the error, the field with the constraint that causes the error is CorrespondenceTemplateID:

Set Identity_Insert IARTS..CorrespondenceLog On

Deleteacl

OutputDeleted.CorrespondenceLogID,

Deleted.CorrespondenceMethodID,

Deleted.CorrespondenceTemplateID,

Deleted.Loc_Prof_ID,

Deleted.Src_Sys_Tx_Type_ID,

Deleted.Tran_ID,

Deleted.CorrespondenceSetID,

Deleted.ReceivedDate,

Deleted.VRTDocumentID,

Deleted.Subject,

Deleted.SentIndicator,

Deleted.Comment,

Deleted.CorrespondenceFO,

Deleted.PrintedDate,

Deleted.PrintByBatch,

Deleted.CreatedBy,

Deleted.CreatedDate,

Deleted.Void,

Deleted.VoidedBy,

Deleted.VoidedDate,

Deleted.ERMSStatus

IntoIARTS..CorrespondenceLog

(

CorrespondenceLogID,

CorrespondenceMethodID,

CorrespondenceTemplateID,

Loc_Prof_ID,

Src_Sys_Tx_Type_ID,

Tran_ID,

CorrespondenceSetID,

ReceivedDate,

VRTDocumentID,

Subject,

SentIndicator,

Comment,

CorrespondenceFO,

PrintedDate,

PrintByBatch,

CreatedBy,

CreatedDate,

Void,

VoidedBy,

VoidedDate,

ERMSStatus

)

FromArchive..CorrespondenceLog acl

Whereacl.CorrespondenceLogID In (1337 CorrespondenceLogIDs)

That's weird Lowell (thanks by the way). I have an entire archive job that is currently running with the exact same syntax as my original post, but without the table...

Lowell (6/10/2011)

---

ok one imporvement i see is some out of date statistics on the Table CorrespondenceLog;

the estimated plan expecting 4 rows, but the actual ended up using almost 12 million.

can...

I've got it running now in ~4 minutes....but I'll attach it anyway.

Oh boy! I don't know which index did it, but I got it to do my Top 5000 in about 4 minutes whereas previous attempts I had to kill the...

Here's the exec plan.

Edit: By the way, my 'text' field is called "CorrespondenceFO".

Here's my select statement:

USE [IARTS]

GO

DECLARE @getdate-2 datetime,

@Legal int,

@StatusFailed int

SET @getdate-2 = GetDate()

SET @Legal =...

Wow, thanks for the quick reply Lowell!

I don't have to search by that field, I just need to include it in the select statement...does your answer change?

Ah, didn't think about my value being the WORD null.

By the way, the "RowTerminator" option should have a value of "backslash n" inside the ticks, like ''

edit: damnit, still not showing my slash n..........it should be inside the...

I'm going to post a new thread about helping with this exact same topic, but I would do the bulk insert feature, like this:

Bulk Insert IARTS..VINVehicleDescription

From 'F:\VINVehicleDescriptionUpdate.csv'

With

(

FirstRow = 1,

FieldTerminator =...

Fantastic! It works. Thanks everyone.