From the get go, I am not an expert in SQL Server, but here it goes. I am attempting to load on a weekly basis using a DTS package a text file that will vary in length / content into a single column, single row temp table which I will then tranfer into another table.

When I use the wizard to create the DTS package (DTS Import) and specify the file using Fixed width, I am forced to specify a length. If I change the size / content of the file the DTS package fails (smaller file results in 0 records copied, larger file equals more than 1 row).

Is there a better way?
Is this a bug, or am I not using it for the right purposes?

Thx.