Dynamic Flat File Connection Manager Connections
I'm writing an SSIS package to iterate over the MOSS logs directory to import the logs into a SQL Server table (eventually a data mart) where I can write queries to pull out the information I need. What I plan to do is loop over the logs directory structure using a ForEach container and then import the logs. The challenge is that while I can get the file reference to the log into a variable, I need to change the Flat File Connection Manager to point to that folder. This screenshot says it tall.
This is under the Flat File Connection Manager's expression Property.