Phil, I think you and I might make an interesting team. 🙂

I believe a script component is the only way to go. I hope you know VB or C#.

I think...

You might find a few pointers here: http://technet.microsoft.com/en-ca/library/cc966529.aspx

Why should you care? You can always go back and fix that. 😛

Edit: Speel chequer wasn't working

CirquedeSQLeil (10/7/2010)

---

Alvin Ramard (10/7/2010)

---

CirquedeSQLeil (10/7/2010)

---

Sounds like a college exam to me. Or...

CirquedeSQLeil (10/7/2010)

---

Steve Jones - SSC Editor (10/7/2010)

---

Thanks for the notes, and it was a nice day yesterday. Alvin wins a prize, but everyone is appreciated.

Plus beer's and BBQ are on...

CirquedeSQLeil (10/7/2010)

---

Sounds like a college exam to me. Or maybe the calculator...

I like Steve's advice. I prefer using SSIS but I know this not everybody feels the same way. That's why I did not recommend it.

You could use Bulk Insert to upload the data into a temporary table then compare that data with what's in the permanent table.

Dave Ballantyne (10/7/2010)

---

IMO a points based system leads to worse answers as people chase the points posting the easy answer.

Issue such as pointing out poor design leading to scalablility issues...

Thanks Steve. Also thank-you RedGate and all others who have something to do with this site being here.

Thanks to all those who try to help others.

The main...

SSIS packages are always saved as .dtsx files

Jack Corbett (10/7/2010)

---

Grant Fritchey (10/6/2010)

---

Maybe I've gone round the bend. Possibly senility has finally kicked in good and hard. Maybe it's just me, but does this sound a little bit...

Greg Edwards-268690 (10/7/2010)

---

Alvin Ramard (10/6/2010)

---

Wow, thanks Steve....