Sorry... post deleted.  Looking at it all again.

Change all the /100 things to /100.0

It worked find for me as just \ n (without the space).  The 0x0a thing will also work.  For those that are reading this and don't know, that is the...

Ah... my apologies.  It's only...

It's no longer needed if you have the later versions of SSMS.  It's actually a setting now and, IIRC, it also...

• This reply was modified 5 years, 9 months ago by Jeff Moden.

I did run some tests. On SQL 2014 it is taking approx 8 - 10 hrs and on SQL 2017 it is taking less than 2 hrs. I can't...

Heh... "Computing Revolution".  I call it the "Dust Revolution" because data and code is just like dust... it accumulates on horizontal surfaces (and sometimes sticks to vertical surfaces in the...

It's the nature of the beast and, to be honest, the brackets are the preferred method (in SQL Server, anyway) for using reserved words and object names that contain spaces,...

BTW... I left a bit of a test in the table creation code and you should change it.  The first column should be a BIGINT and not VARCHAR(11).

p.s.  Try it with my changes to the table and the BULK INSERT command first without doing the powershell stuff.  I don't know if I just had a bit of...

The Powershell code will work on any PC.  Although it doesn't need to be, I installed it as a .bat file in the same directory as the file.  That makes...

Ok... I got this working BUT...

The bastards lied on their record layout.  The "HEALTHCARE_PROV_TAXONOMY_GROUP_xx" columns aren't 10 wide in the data... they're up to 43 characters wide.  I changed the...

That particular problem is because there's a head row that you're not skipping.  Add the following to the options in the BULK INSERT command...

FIRSTROW = 2,

I tried the same thing...

Speaking of tenacity, that's some Awesome feedback!  Thank you for taking the time to share what you found all across the board... especially the 4 space duplicate key error.  I've...

For me, it's not a matter of being resistant to change or something new.  My problem is that I've seen all manner of supposed "improvement" and supposed "better ways to...