Freigeben über


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.