Newbie question about transformation

• sryan-382759

  Valued Member

  Points: 69

  More actions

  January 29, 2007 at 8:46 pm

  #116073

  I'm new to SSIS and tryint to create my first package.  I have a source file that I'm reading in as text b/c the data is inconsistent (ex., a null date value is represented by zero). I need to do some transformation, such as check a date value is equal to zero, etc.  I found the script transformation task but it seems like overkill. Is there any easy way to do this?

• Michael Riedmueller

  SSC-Addicted

  Points: 429

  More actions

  January 30, 2007 at 5:57 am

  #686413

  Hi,

   

  I would try a derived column transformation in your case.

   

  Michael