Looks good, but for the purposes of what I'm doing, this is overkill.  (I'm a big believer that simpler is better.)  I went ahead with the simple check I posted...

I concur – I did see something in BooksOnline that said you had to use the full qualifier for tempdb.  Once I put in the qualifier, it worked like a...

Or better, should I do this?

if object_id() is null or object_id() = 0

?

First, thanks for the assistance!

So far, it seems to be behaving better.  Of course, with the "##" tag, it's a temporary table, but...

As we say here in New York, "you da man!"

Thanks again for your help!

I'm getting "Incorrect syntax near the keyword 'join'."

Ideas?

Got it! Thanks for the assist!

Trouble is, the fields **ARE** the same name. (I'm assuming "fields" and "columns" are interchangable in this context.)

As an experiment, I tried performing a join on another table in...

Wow – I didn't expect to get this many responses to what I thought was a simple topic!

I finally came up with a workaround. I...

Thanks for the feedback; unfortunately, this doesn't help me.

I need to eval **every value in the column** [Elapsed Time].

My original post isn't entirely accurate, so let me clarify what I'm...

I just confirmed the problem. The file itself has duplicate lines; therefore, it violates the unique key when I try to import.

I created two test import files. I...

For the information of anyone looking at this thread: it turns out that I was trying to import using the default datafiletype (that is, native). When I used the...

It's not working. 🙁

Just for grins, I set -L to 2, and am still getting the same EOF error. Could it be that it's not reading the linefeeds correctly?

The...

I *almost* got it to work!

It turns out the -q option does in fact allow the bcp command to recognize spaces in the database and table names. I tried...

Right after my last post, I found the following on MSDN:

"To specify a database name that contains a space or quotation mark, you must use the –q option."

Am going to...