SQL Server Performance

Different row delimiter in Flat File Connection Manager

Discussion in 'SQL Server 2008 Integration Services' started by WingSzeto, May 12, 2009.

  1. WingSzeto Member

    When creating a flat file connection manager, the default row delimiter is {CR}{LF} and there are seven othe choices. What if all these choices are not suitable for my usage and I want to create my own, is there a way to do it? For example, I want to use ##&&** as a row detimiter.
    If there is a way, can I define it as a parameter or variable so I can pass it to the package before the execution? This way I can choose when to change the row delimiter.
    Any help on this is very much appreciated.
  2. satya Moderator

    IS there any specific reason to use you own delimeter than default?

Share This Page