SQL Server Performance

Limitation - DTS import fixed length text file

Discussion in 'SQL Server DTS-Related Questions' started by ficisa, Jul 27, 2004.

  1. ficisa New Member

    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

Share This Page