How can I ignore any error during the lengthy process? I indicate -e option but still got terminated,

Here is the bcp:

bcp Test.dbo.Test in C:\Rxie\SQL\20150902FullTest.rpt -f C:\Rxie\SQL\Test.fmt -T -F2...

Thank you Luis,

I am to start bcp all the data now and see how long it takes to complete all the 39977139 rows.

Thanks Luis, here is the new result:

SQLState = S1000, NativeError = 0

Error = [Microsoft][SQL Native Client]Incorrect host-column number found in BCP format-file

Luis Cazares (9/2/2015)

---

Your problem was that the table didn't match the file.

I suppose that that's what you found out (or maybe something we couldn't see).

I suggest you to read the...

Please discard this post, I will report to Steve to remove it completely.

I am to start everything again.

I am deeply sorry to this and want to apologize to everyone who...

I corrected an error in the format file, please use the new one attached here (change the .txt to fmt please), error becomes:

SQLState = 07006, NativeError = 0

Error = [Microsoft][SQL...

GilaMonster (9/1/2015)

---

Maybe

Depends if the index is useful to the query and the query capable of using the index.

Not knowing how you're replicating the data, it's a little hard to suggest...

varchar(1000)

1. Is this a one-off...

Thank you all replies.

As the data is really confidential and I can't risk to expose myself under any uncertain situation, so I am sorry I can't tell any real data...

I agree with you.

I asked previously if there is a way to isolate the portion that you need to search for. Thinking if you could parse that part into its own column then...

Sean Lange (8/7/2015)

---

halifaxdal (8/7/2015)

---

Sean Lange (8/7/2015)

---

halifaxdal (8/7/2015)

---

Thanks Sean.

The table contains daily data that to be analyzed to find out those fit into certain criteria, that's what the query is for....

Sean Lange (8/7/2015)

---

halifaxdal (8/7/2015)

---

Thanks Sean.

The table contains daily data that to be analyzed to find out those fit into certain criteria, that's what the query is for. I don't know...

Thanks Sean.

The table contains daily data that to be analyzed to find out those fit into certain criteria, that's what the query is for. I don't know what else you...