Post reply

Using non typable ASCII characters as delimiters for a flat file connection

  • December 15, 2011 at 11:01 am

    #264874

    Hello everyone,

    Can we use non typable ASCII characters as delimiters for a flat file connection manager in SSIS 2005/2008. Please suggest

    Thanks and Regards,

    Praveena

  • December 16, 2011 at 12:04 am

    #1422321

    venus.pvr (12/15/2011)

    Hello everyone,

    Can we use non typable ASCII characters as delimiters for a flat file connection manager in SSIS 2005/2008. Please suggest

    Thanks and Regards,

    Praveena

    If you cannot type them, how are you going to configure the flat file connection manager in SSIS?

    Which non-typacle characters are you considering?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 16, 2011 at 7:50 am

    #1422518

    sorry I wasn't clear on my question. I would like to use ASCII 31 and ASCII 30 as field and row separator in the flat file manager. Is there a way to accmplish this?

    Thanks and Regards,

    Praveena

  • December 16, 2011 at 8:01 am

    #1422527

    Did you try?

    I just set up a source connection and it *seemed* to work.

  • December 16, 2011 at 8:12 am

    #1422538

    @Phil: I typed ASCII 30 in the delimiter field and it actually used the string "ASCII 30" as the delimiter. I am sure thats not the right way as it worked for you. Please let me know how did you specify. thank you very much

  • December 16, 2011 at 8:18 am

    #1422547

    I see. OK - I put an ASCII 30 character into a Word document, then copied that to the clipboard, then pasted it into BIDS.

  • December 16, 2011 at 9:57 am

    #1422617

    @phil:Thank you very much. It worked

  • December 16, 2011 at 9:59 am

    #1422619

    No problem, thanks for posting back.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply