Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 for each loop files in folder starting with @[User

Author  Topic 

shanmugaraj
Posting Yak Master

219 Posts

Posted - 2012-12-02 : 02:55:38
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



THANKS
SHANMUGARAJ
nshanmugaraj@gmail.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-02 : 03:22:15
How were you setting this? You should be setting this inside Connections tab of for each loop in expression builder for the FileSpec property

see

http://i1064.photobucket.com/albums/u362/visakh16/SSISExpFEL.png

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

shanmugaraj
Posting Yak Master

219 Posts

Posted - 2012-12-02 : 03:35:40
thanks
i got the soln
quote:
Originally posted by visakh16

How were you setting this? You should be setting this inside Connections tab of for each loop in expression builder for the FileSpec property

see

http://i1064.photobucket.com/albums/u362/visakh16/SSISExpFEL.png

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





THANKS
SHANMUGARAJ
nshanmugaraj@gmail.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-02 : 03:38:56
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -