I wonder what is the best way to import data from fixed length record text file into SQL.
SQL Server 2000 DTS supports text format import.
I have data in many fixed length ASCII files. I want to have a program to import/export them. Since SQL does not seem to direct support fixed length, do I have to define a format file?
Another possibility is to make your own program reading text file according your rules and sending data to SQL through ODBC or ADO connection.