Yes, it's the same login & PW for VPN.  At home, where it works,  I use a wireless card.  At work I use an Ethernet 10/100 LAN PC Card.  Otherwise...

It's odd that at my home the authentication works from the vpn login, and from the work site it doesn't.  One clue might be that the work site used to...

Thanks EdVassie for the detailed & thoughtful reply.  The problem, which I keep restating so it's understood, is that I have csv files that need to be imported to SQL Server.  The...

I understand clustered indexes.  What I don't fully understand is DTS. 

My question:  If DTS imports a csv file with no primary key, will the resulting table be in the...

Then I assume I can be sure rows are transfered to the destination SQL table in the same order as the source csv file.

I'll go with that (unless someone out...

Sounds good.  I'm going to try that, but it will be a few days before I'm back in the office.  Let you know how it goes then!

Got this one wrong, but notice I'm currently with the majority

I would choose to backup & restore in...

Yes, I configured for mixed mode and now I can connect from winXP to win2k via sql auth.  I can connect from win2k to winXP using sql or windows auth via...

Thanks - configuring to mixed mode works so I can connect through the sa (and I assume any other) sql server account.

I still wonder...

Another old one that applies to IT:

GIGO - Garbage In, Garbage Out.

OK - I guess there's no DTS version of Excel's option of treating consecutive delimiters as one.

I'm really not much on DTS, so I thought someone else would come up...

No, it's not fixed width, at least not consistently enough.

Thanks for the advice.

The only normal people are those you don't know well - Oscar Wilde

I noticed that too. But my import data is space delimited & has varying amounts of spaces between data.

I did get import to work by DTS to another text...

Good points - in the perfect world we would all use the month name (JAN, FEB, etc..) or YYYYMMDD formats. (YYYYMMDD also sorts well as a number or character...

Wonder if there is a workaround, by changing the columns that might have longer data to type text, which I understand isn't constrained in total length to 8K.