Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Unanswered: SSIS: Flat File Source w/non-standard row delimiter

    I have a flat file that is row delimited by \x00 \x0D \x0A. Any ideas on how to specify the row delimiter in the Columns section of the Flat File Connection Manager?

  2. #2
    Join Date
    Apr 2006
    Posts
    33
    Try this:

    Create a new flat file connection.
    Select your flat file
    Click Columns
    Type/Paste your row delimiter - the list is predefined but it's possible to type something else in.
    David Wiseman
    MCSE, MCSA, MCDBA

    www.wisesoft.co.uk

  3. #3
    Join Date
    Jun 2006
    Posts
    2

    Follow-up

    Thank you for your response. I tried copying from the file, as well as several other variations to see what might work. For example {\x00}{CR}{LF}, \x00{CR}{LF}, etc. Nothing I have tried was successful.

Posting Permissions

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