Expressinj for Folder path issue

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  August 13, 2015 at 8:47 pm

  #149008

  Hi Below is me expression

  @[$Package::V_FilePath] +"MD_GEOGRAPHYLEVELXREF_"+ @[$Package::V_Zone] +".txt"

  H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELXREF_US.txt

  I am looking to have path like

  H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Outbound\MD_GEOGRAPHYLEVELXREF_US.txt

  I want fit outbound in my expression.

  regards,

  Vipin Jha

• Jack Corbett

  SSC Guru

  Points: 184388

  More actions

  August 14, 2015 at 1:28 pm

  #1820208

  vipin_jha123 (8/13/2015)

  ---

  Hi Below is me expression

  @[$Package::V_FilePath] +"MD_GEOGRAPHYLEVELXREF_"+ @[$Package::V_Zone] +".txt"

  H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELXREF_US.txt

  I am looking to have path like

  H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Outbound\MD_GEOGRAPHYLEVELXREF_US.txt

  I want fit outbound in my expression.

  regards,

  Vipin Jha

  Well, you have 2 options:

  1. Add that to the package parameter V_FilePath value when you are passing it in.

  2. Change your expression to:

  @[$Package::V_FilePath] +"Outbound\MD_GEOGRAPHYLEVELXREF_"+ @[$Package::V_Zone] +".txt"

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question