get only filename from variable

• Soulfly73

  SSC Veteran

  Points: 285

  More actions

  October 12, 2010 at 1:03 pm

  #145639

  Hello all,

  i have a SSIS package with a for each file loop.

  I use a uservariable user:filename, now the actual name (for instance 110.csv) is the 110. This name i want to use as a derived column into a table, but I can't find out how I only can get this string (110) in a separate variable, I know i probably should use a expression but that's all what i can think of. Is there anyone who can give me a hint or solution to this?

  Thanks in advance,

  Peter

• Derrick Smith

  SSChampion

  Points: 10833

  More actions

  October 12, 2010 at 1:04 pm

  #1235813

  If it's always .abc (period, 3 letters) then you can just do this..substitute with column name if selecting from a table or CTE.

  select left(fieldorvariable,len(fieldorvariable)-4)

• Soulfly73

  SSC Veteran

  Points: 285

  More actions

  October 12, 2010 at 1:07 pm

  #1235815

  thanks derek, for the quick response and answer. I give it a try immediately and will let you know.

  Peter