Results 1 to 3 of 3

Thread: can't import text file fixed length

  1. 04-21-2003, 04:43 PM #1
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261

    can't import text file fixed length

    Will be getting new file for download from vendor to process in future. When I use DTS or Import wizard in sql server I get "could not find the selected row delimiter within the first 8kb of data, is the selected delimited valid? This is for a fixed length file. If I answer yes and continue everything is fine, until I get to the end of the record which it can't find. It basically lumps the records together. What is interesting, that if I import the same file in Access 2000, I don't get this problem. ANyone seen this before? Could not find anything on MSDN
    Reply With Quote Reply With Quote
  2. 04-22-2003, 07:40 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You may have to find out what's row delimiter used in the file and make change in dts.
    Reply With Quote Reply With Quote
  3. 04-22-2003, 03:07 PM #3
    andi_g69
    andi_g69 is offline Registered User
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    Another reason for this behaviour might be that your records in the flat file are variable length, e.g. the last field is not padded with spaces and / or the last field is omitted.
    This is a known issue in DTS Import. You can work around this by importing the file as single field CSV and pump it back into flat file fixed format with spaces padded to the end of each record
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules