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.

Skip to main content