Cleaning data from a file..in Control or Data flow step?

• jsheldon

  SSCertifiable

  Points: 5250

  More actions

  January 10, 2008 at 2:34 pm

  #119536

  I have a flat file I want to bulk insert into a temp table. One of the source columns is a money column.

  The data in the original flat file is without decimal. 55015 is really 550.15

  So I want to take the column and divide by 100, I think I do this in SSIS on the Data Control tab of my package, using 'Data Conversion' Data Flow transformation task.

  yet not seeing how I can achieve my result.

  Thanks

• Ed Zann

  SSCrazy Eights

  Points: 8694

  More actions

  January 10, 2008 at 2:43 pm

  #766887

  You may have to do 2 things:

  1 - Data Conversion ( if your original field is coming in as an integer type this is where you cast it to a decimal type)

  2 - Derived Column ( this is where you do the divide by 100 )

  Ed

• jsheldon

  SSCertifiable

  Points: 5250

  More actions

  January 10, 2008 at 2:47 pm

  #766889

  Hi Ed,

  Thanks I have the value coming in as a decimal format already (expecting to convert so I said might as well place in the data type it should be)