Import it into a table using SSIS. Create the table before import and add the ID column with the IDENTITY property.

You probably need a full outer join.

Also check the first link in my signature on how to ask questions on forums.

It will make life easier for people trying to help...

Maybe you can try to do a repair of BIDS? (or maybe a re-install)

TheSQLGuru (7/30/2013)

---

Fortunately for you SQL 2012 has much better Windowing Function support. Look into the PERCENTILE_CONT function. I also HIGHLY recommend you purchase Itzik Ben-Gan's SQL Server 2012...

Easy one today, thanks.

nealz (7/31/2013)

---

Thanks! I think I see the problem. Line 153: there is a rogue comma in the data in a preceeding field: "Thomas, Dean ...

The errors are quite specific.

There's a truncation at line 153 for column FIN_ACCI_TITLE.

nealz (7/31/2013)

---

Hi. We get the same error. The excel import works fine, but what causes the error for the flat file CSV import, and how did you overcome...

It is not necessary, it depends on the requirements. If you never going to analyze on location, it is not necessary.

However, if you would like to answer questions like "which...

Back to basics. Thanks for the question Steve.

Grant Fritchey (7/30/2013)

---

SQLRNNR (7/30/2013)

---

Koen Verbeeck (7/30/2013)

---

SQLRNNR (7/29/2013)

---

L' Eomot Inversé (7/29/2013)

---

WayneS (7/29/2013)

---

Just curious - how many like that new tile look on the home page?

FWIW: I prefer the older images over...

Regarding the address: typically you would store the street and number in one field, but zipcode, town and country in other fields. Maybe in a different dimension altogether: the geography...

You do realize this thread is...

I would open up the solution in visual studio and change as much as you can in there.

All the rest you'll have to change by opening up the XML and...

Grant Fritchey (7/30/2013)

---

A pretty common use of unique keys is when you have an artificial primary key for a table, the single most common example is the identity field, but...