Update the column in a flat file using Script task

• aravindkumar.porwal

  SSC Enthusiast

  Points: 100

  More actions

  July 1, 2009 at 7:10 am

  #211719

  Hi friends,

  I want to update the Flat file column b4 using it into the data flow task.

  For ex : I have a flat file which has months column having values jan,feb, mar so on, i want to update the flat file (.txt) b4 using it as a source in the data flow task.Months should be represented as numbers like for jan replaced by 1, feb replaced by 2 ..... in the flat file.

  numerical values(Reference values) can be taken from table.

  can anyone help with code used in the Script task

  please,

  Thanks in advance

  Arvind

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  July 1, 2009 at 8:18 am

  #1018437

  I think there is a better way..

  As a matter of fact I can think of two..

  First way (best):

  1. Build a table that contains the text values and the id of the month

  MonthId, MonthAbbr

  1 Jan

  2 Feb

  etc..

  2. In the Dataflow use the lookup dataflow transformation, use the Month Abbreviation to output the MonthId.

  Second way (ok):

  1. Use the derived column dataflow transformation and build an if/then/else kind of logic in the expression, not pretty..

  CEWII

• aravindkumar.porwal

  SSC Enthusiast

  Points: 100

  More actions

  July 1, 2009 at 1:38 pm

  #1018677

  Thanks CIWII for the reply. This is easier way to do it.:-):-)