Creation of flat file with dynamic delimiter

• NIRANJANA1977

  SSC Eights!

  Points: 854

  More actions

  April 23, 2009 at 7:28 am

  #130216

  Hi All

  I have come across typical requirement. I want to generate flat file by combining two or more tables. The expected flat file delimiter should be dynamic. i.e. if the variable value contains '|' then it should be | delimited, if variable value is ';' it should be ; separated and if variable value sets to ',' it should be generated as comma separated.

  Please help.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 23, 2009 at 8:00 am

  #982922

  How are you doing the output? If it's through SSIS, I believe you can set the delimiter dynamically through a variable.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon