Al has a good idea.  As a teen, before cell phones and when dinosaurs roamed N. America, I lived in rural Illinois.  I had a VHF ham radio setup so...

Thanks, Peter. 

Nicely done, Michael and Jeff.

If you can finagle all the transformations into a single transaction, you can do this:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

BEGIN TRANSACTION

-- do your transformations here

...

COMMIT TRANSACTION

There are some good articles on this site...

From BOL:

The computer running SQL Server must be set up as an e-mail client. SQL Server Enterprise Manager is used to assign an e-mail account and password to the SQL...

OK, that was weird.  Let's try it again.

You can create an INSERT trigger on the table into which you insert the CSV data from your network logon.  Something along the...

You can create an INSERT trigger on the table into which you insert the CSV data from your network logon.  Something along the lines of

CREATE TRIGGER AfterInsertLogonCSV ON LogonCSVAFTER...

Joel, schleep is correct.  You could, however, use a base table or a local temp table.

OK, that makes sense.  Thanks.

"Typically, you know when tempdb is being hammered when you are in enterprise manager and you refresh the view on tempdb.  In our environment, if tempdb is being hammered, we...

OP, did you get it going?  By now, you probably could have typed it into EM. 

Do you actually have a rectangle in the spreadsheet?  There are the same number of columns in every row? 

<long shot>

What if you open the spreadsheet, format the SSN field as general, and then try to import it into a varchar(9)?

</long shot>

Have you defined the table explicitly, or are you letting DTS do that for you?  If not, you might want to

CREATE TABLE dbo.NameSsn (EmployeeName varchar(50), EmployeeSsn varchar(9))

then in your...

Or, option B, what if I add a file to tempdb on my D: drive (which has 136GB free)?  If I don't let tempdb autogrow, but instead set the primary file to 146GB and...