for each loop files in folder starting with @[User::strFileNameStart] + "*.csv"

• Shanmuga Raj

  Ten Centuries

  Points: 1178

  More actions

  December 2, 2012 at 12:52 am

  #267673

  I have an folder with multiple files .

  For passing the folder, i have set the Directory expression as

  @[User::strFinSourceFolder] + "\\"

  I want to select files starting with USA.

  File loop works fine when i add the Files textbox as

  USA*.csv

  I add the parameter instead of USA in the files textbox as

  @[User::strFileNameStart] + "*.csv"

  But things are not even entering into the loop ...

  Please help me how to set the filename start in the for each loop

• Shanmuga Raj

  Ten Centuries

  Points: 1178

  More actions

  December 2, 2012 at 1:36 am

  #1564676

  i got the soln.. by using filespec

  thanks

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=181108