SQLServerCentral / SQL Server 2005 / SQL Server 2005 Integration Services / for each loop files in folder starting with @[User::strFileNameStart] + "*.csv" / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 21:52:26 GMT20RE: for each loop files in folder starting with @[User::strFileNameStart] + "*.csv"http://www.sqlservercentral.com/Forums/Topic1391702-148-1.aspxi got the soln.. by using filespecthankshttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=181108Sun, 02 Dec 2012 01:36:36 GMTShanmuga Rajfor each loop files in folder starting with @[User::strFileNameStart] + "*.csv"http://www.sqlservercentral.com/Forums/Topic1391702-148-1.aspxI 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 loopSun, 02 Dec 2012 00:52:33 GMTShanmuga Raj