Your request could be taken multiple ways, I think. If you have a moment to spare please post a table definition (CREATE TABLE statement), some sample data (INSERT statements), your...

bicky1980 (1/2/2013)

---

I am currently attempting to do this in the following manner:

declare @sql nvarchar(1000),

@totalrecs int

set @sql='insert into source select...

I do, just wondering how the spreadsheet you shared was created. Deleting extra rows + save As or copy rows into a new sheet. It could have made a difference...

I meant in the one you attached to this thread. How did you construct the one you attached, the one I was able to load with no issues?

GilaMonster (1/2/2013)

---

No.

I thought a rebuild would re-scan the clustered same as a drop+recreate which would work since all inconsistencies were found in the nonclustered...

DB_Newbie2007 (1/2/2013)

---

LOL. Sorry... problem with being at work with a cold? Not enough coffee yet? Actually, I ran both DBCC CheckDB (last week) and CHKDSK (today), no errors with either....

The internal change tracking tables reside in...

Bhuvnesh (1/2/2013)

---

If you go with the basic structure of HASH join then you will find that temp table get created (either in memory or tempdb) which might the cause of...

No, I do not think nested loops would...

Makes perfect sense. You're quite welcome.

Did you mean DBCC CHECKDB or the operating system routine CHKDSK?

xp_readmail is for SQL Mail, which is deprecated.

In my opinion this kind of work should be done way far away from the database engine. There are many applications out there...

Why didn't I have trouble loading the data? Did you post a modified version of the original spreadsheet?

I owe a great deal to the kind folks who...

Sure. Use a batch separator to separate different "chunks" of...