Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

for each loop files in folder starting with @[User::strFileNameStart] + "*.csv" Expand / Collapse
Author
Message
Posted Sunday, December 2, 2012 12:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 7:17 AM
Points: 62, Visits: 321
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
Post #1391702
Posted Sunday, December 2, 2012 1:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 7:17 AM
Points: 62, Visits: 321
i got the soln.. by using filespec
thanks
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=181108
Post #1391704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse