SQL Server Performance Forum – Threads Archive

Limitation – DTS import fixed length text file

Hello, I’m trying to import a fixed length text file into a SQL Table. The record length in the text file is rather long, 7200 characters. Is there a limit on the row length for DTS? Because when I set up the property for the source text file, and click to set up the fields, it wouldn’t let me go beyond 4095 character. Whenever I try to set a line beyond that point, it will either jump over to the very beginning of the line or do nothing. Could anybody shed any light on this? Is there any other workaround? Thanks very much! ficisa

---

]]>