We have a need to import fixed width text files into our SQL Server instance. The width of the file is 4922 characters. In using the import wizards with DTS we seem to hit a limit of 3900 characters (I believe 3907 is the exact figure).

How can we work through and/or around this issue and import the file directly?

Any direction and or help with regards to this issue would be greatly appreciated.