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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » for each loop files in folder starting with...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Shanmuga Raj

Posted Sunday, December 02, 2012 12:52 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 1:19 AM
Points: 20, Visits: 157

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

Shanmuga Raj

Posted Sunday, December 02, 2012 1:36 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 1:19 AM
Points: 20, Visits: 157

i got the soln.. by using filespec
thanks
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=181108

Post #1391704

« Prev Topic | Next Topic »

Permissions