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

Question

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

venus.pvr

SSCarpal Tunnel

Points: 4813
More actions
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

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

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

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 1

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

venus.pvr SSCarpal Tunnel Points: 4813 More actions · Answer 2

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

Phil Parkin SSC Guru Points: 247158 More actions · Answer 3

Did you try?

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

venus.pvr SSCarpal Tunnel Points: 4813 More actions · Answer 4

@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