I think I got this Foreach Loop to work, thanks!

I used the SSIS|Variables menu item to set the value of my variable to H:\James\Intex_to_Securities\Test_Source_Files\AAM0301.csv. I get the same error I did before.

Back to the original Foreach Loop, I followed these steps:

1. Added the Foreach Loop Container and added the existing Data Flow Task to it.

2. Set the Container's Enumerator...

Just out of curiosity, I noticed that my source filenames have different lengths. How do I derive just the file name (no extension and no path) when the filenames...

I have two questions:

1) Is the Multiple Flat File Connector exclusive to 2008 or is it also available in 2005?

2) How exactly do I get the Foreach Loop to send...

I have another question. This method stores the file name. What if I want to get other file information such as file size, file date, etc.?

I'm an old SQL Server guy, so I agree with you guys. It's just that we've had some proof of concept tests, with me advocating SSIS. For one...

In "The Data Warehouse ETL Toolkit" Ralph Kimball argues that there are certain productivity gains when you use a dedicated ETL tool that keeps the interim steps in memory instead...

This will be excellent for me. Thank you very much.

Thanks again!

That worked, thanks!

I believe it is one file, but the name is dynamic. Could the loop work if there is technically only one file?

Exactly! For example, let's say there is a "Group" column in the data set. Based on that value, the output file should go to either:

\Main Directory

\\ Group 1

\\...

Good advice! Now how can I automatically derive the path and filename of the file?

Does that discussion apply to Oracle 11g? I think that is the version we are using here.