SSIS Expressions

• DBayliss

  Mr or Mrs. 500

  Points: 530

  More actions

  April 13, 2015 at 8:37 am

  #398316

  Would anyone able to help with the below SSIS Expression?

  I need to extract the excel file name out of the filepath - see below example;

  'c-Drive\Files\Data\Claims\Current Load\31 Dec 2012.xls' ==> need output to read '31 Dec 2012'

  Could someone help point me in the right direction.

  Thanks in advance for any help.

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  April 13, 2015 at 8:47 am

  #1790541

  This works, as long as the folder hierarchy depth is always the same. If not, you'll have to get more complex & use TOKENCOUNT too.

  token(token("c-Drive\\Files\\Data\\Claims\\Current Load\\31 Dec 2012.xls","\\",6),".",1)

  ---