PS, I already removed the first line as well as the last line from the data file.

patrickmcginnis59 10839 (10/22/2014)

---

The file you have uploaded called EmployeeDataCommaDelimited.csv.txt looks like it should work with the prior bcp command you first tried, AFTER YOU REMOVE THE FIRST LINE FROM YOUR...

Here is my finding using a format file to do the bulk insert:

I generated the format file (attached here for your convenient, please change Employee.fmt.txt back to Employee.fmt) using:

bcp AdventureWorks2008.HumanResources.Employee...

Thanks Patrick and Jeff.

I recreated the data source and specify comma as delimiter, I've attached the data source file here for your convenience.

The data source file is generated this way...

patrickmcginnis59 10839 (10/21/2014)

---

Just some possibilities:

It can depend on the table its getting loaded to and the parameters you have in your bcp command and I don't have adventureworks loaded.

Some other...

GilaMonster (10/16/2014)

---

Developer edition is the equivalent of Enterprise edition in terms of features, but it is licensed for non-production usage only. You may not use it for production systems at...

Nice article and nice experiment, but unfortunately from security perspective I am not able to even give the needed SQL# a try simply because SQL# has lots highly restricted features...

interesting summary article, worth to save for later use

SQLRNNR (8/18/2014)

---

halifaxdal (8/18/2014)

---

I like the word "handcuff", that's not by me, it's by the platform itself, I am building a dashboard...

I like the word "handcuff", that's not by me, it's by the platform itself, I am building a dashboard using Dundas...

SQLRNNR (8/18/2014)

---

So use a temp...

unfortunately CTE is not allowed in this particular staging table creation, and even if it is allowed, 10 million records would be a lengthy dump.:crazy:

Eirikur Eiriksson (8/16/2014)

---

halifaxdal (8/16/2014)

---

Thanks for the discussion but I am sorry I didn't see that your reply is talking my question here:

What I am looking for is a simple query...

Thanks for the discussion but I am sorry I didn't see that your reply is talking my question here:

What I am looking for is a simple query (with no declare,...

things getting complicated so quickly, the raw data contains also some domains that actually not domains but IP address, so I also need to bypass those records:

For records like: abc.com,...