I concur w/mimorr - add a value to the end of the first row of the text file to cause DTS to recognize the correct # of columns.

I have a...

A recent tip in Smart Computing magazine suggested setting the swap file minimum and maximum to the same amount at about 2.5 x memory. This is to reserve the...

I'm not sure if I understand your requirements of a "low tech interface", but if you're using T-SQL, then I'm guessing you're somehow connected to a SQL Server box. ...

Well, it now appears the problems have been caused by a corrupted hard disk. Today I received the following msg "The file system structure on the disk is corrupt...

Thanks, Antares686.

Still no luck (I'm almost disappointed that there were no errors: CHECKDB found 0 allocation errors and 0 consistency errors). At least then I would have had an...

Thanks.

At least I know I'm not the only one to have run into this. However, while the error message was the same, I have not re-attached a db, other...

More info:

Running the SQL in Query Analyzer generates the following:

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times:

...

I recently wanted to do something similar. The following site provides great information on how to do this with an activex task, which can of course be scheduled. ...