SSIS Import issue

• Todd Wojtkowski

  SSC Veteran

  Points: 290

  More actions

  November 13, 2007 at 10:14 am

  #126984

  I have an SSIS package that imports a flat file. The file is comma delimited with quote text wrappers.

  The problem is I'm getting this file from a third party source and for some reason before the quotes there is an equal sign.

  I need to strip the equal sign out before I attempt to import the file. Please help.

• ravikumar-490768

  SSC Veteran

  Points: 208

  More actions

  November 19, 2007 at 5:00 am

  #752201

  Try "Replace" Function in derived Column Transformation to replace "=" sign with an Empty string and import data to destination