Expression in derived column to replace a string value in column to db NULL

• Jyoti-J.Bhatt

  Newbie

  Points: 9

  More actions

  October 1, 2012 at 9:48 am

  #262475

  Hi,

  How do I write a expression in derived column to replace a string value in column to db NULL value?

  Thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  October 1, 2012 at 4:45 pm

  #1544189

  SSIS NULL Function

  SSIS Replace Function

  Example where 10 is the length of the string and 1252 is the Encoding:

  REPLACE(IncomingColumnName, "String you want to replace", NULL(DT_STR,10,1252))

  Example where 20 is the length of the string and the string is in Windows "Unicode":

  REPLACE(IncomingColumnName, "String you want to replace", (DT_WSTR,20))

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato