Importing Fixed Length Text File

[shep6]

I need to import a large text file into SQLServer 7 (approx 400 fields), it is a fixed length file. Can anyone tell me how to specify the field positions when importing the data via DTS (eg. in Access I use an import spec).

The only way I can see to do it in SQLServer is to manually drag the column dividers in the import wizard.

Any help would be appreciated

thanks