I have a flat file with column delimiter of Group Separator. I can see the GS in notepad++ but the connection manager is not picking it up. Is there any way to have the connection manager pick this up? ctl-]

Hello, You can enter the delimiter manually.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Thanks for the response. I entered it manually and still is not picking it up.

You mean, the data in the preview is still the same? After changing the delimiter you have to refresh the view.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

I did refresh. Still the same result. It recognizes the Row Delimiter without issue but it is common LF.

It recognizes the Row Delimiter without issue but it is common LF. Sorry, I don't get what you mean? Can you please explain more detailed how your source file looks like, what you entered in flat file source and what result you get.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

This is how SQL Parses it one big string 20111223-04541002I291217826710015624328139029-09-2011 Connection Manager does recognize {LF} which is the Row Delimiter in this file. When I place in the Column delimeter of (Alt + 29 = Group Separator) and then refresh the file stays in the same form as above

Hi Luther88, Do you mean you are using (alt+29) as Column delimiter in flat file connection manager? I have treid it on my test environment and it cannot use this as Column delimiter also, I am afraid it cannot do that. I suggest you can use script component to parse the column instead of using column Delimiter, and here is a similar thread, please refer to: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/851da74b-fe94-4603-af3d-b3642109f38e/ Thanks, Eileen