Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: DTS Fixed Field length File Limitations

    I am trying to upload a fixed field text file to a sqlserver table using the DTS wizard. The txt file has 111 columns and the total length of a single row is 5897. The problem is when I use the wizard to specify the starting and ending of each column, its not allowing me to specify the columns beyond the position 4095.
    Is there a limitation on this? if so is there a work around ? to solve this.
    Any help on this is truly appreciated.

    Thanks much.

  2. #2
    Join Date
    Nov 2003
    Christchurch, New Zealand
    I've never encountered this problem but then I have never had a file quite that wide.....

    Personally what I would do is write a quick wee app or ActiveX Script to slice the file in half and then do the import in two stages... probably doesn't help much but it's the best suggestion I can give you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts