They couldn't connect.

Even if it was poorly written, that would lock others out? One query can shut down the entire server?

I've had better performance results in Microsoft Access (with more data...

Thanks for the good responses. I will still be battling this issue, but have some hints on how to solve it.

Our company is small and we have only 2...

Tried this, but I still get the same error

That makes sense, but I have tried it on one of our network drives, and it doesn't work either.

It isn't represented as a null, but when I bring in the file, I would like to have the fields represented as NULL instead of a zero length string.

The file is not on the same box as the server. But it is on a server that is part of our internal network.

Below is the code

BULK INSERT DBO.an_STLaw_SampInfo

FROM 'C:\Data\sampling_info_050509_test.csv'

WITH

(

DATAFILETYPE = 'char',

...

No, that is not the goal. The records can be anywhere in the table, and need to be excluded based on field values, not any specific position in the...

There are 2 primary key fields that will work to join to another table, but the remaining fields are dynamic.

The procedure produces a table, but the table fields can be dynamic, so that is the problem. It does not appear that a table can be created with dynamic...