SQL Server Performance

Using ASCII 31 as field separator and ASCII 30 as record separator in SSIS

Discussion in 'SQL Server 2005 Integration Services' started by WingSzeto, Mar 14, 2011.

  1. WingSzeto Member

    Has anyone used the ASCII 31 and ASCII 30 as field and row separator to create a text file in SSIS? I have over 50 text files I need to export data out from our SQL 2005 database. By using these separators, it would avoid any issue with common separators (ie LF CR, |, etc) existed in the content of a field.
    w
    WingSzeto, Mar 14, 2011
    #2

  2. satya Moderator

    Will those exported files usedby your application or another SQL isntance?
    satya, Mar 15, 2011
    #3

  3. WingSzeto Member

    These files are needed by our customers. Some of them use SQL server. I know one is using Oracle. And I am not sure others.
    WingSzeto, Mar 16, 2011
    #4

  4. satya Moderator

    If the source file format doesn't change then you can use the field seperator, as it is being an user-requirement you can follow by testinga samples.
    satya, Mar 17, 2011
    #5

  5. WingSzeto Member

    Thanks for the reply. I am not sure I follow your thought. The source data is from SQL tables. I am trying to use SSIS to turn them into text files with the said field and row delimiter. I tried to use the 'Flat File Manager' to create the flat file destination but the delimiter fields don't allow me to put in custom delimiter. I tried to use the expression there but I don't think they have the fucntion there for me to specifiy delimiters. I attempted char(30) but the expression doesn't recognize this char function.
    If u can help specify the ASCII 31 and ASCII 30 delimiters in the Flat File Manager, it would be highly appreciated.
    w
    WingSzeto, Mar 17, 2011
    #6

  6. satya Moderator

    satya, Mar 22, 2011
    #7

Share This Page