Home Forums SQL Server 2008 SQL Server 2008 - General Question on how to dynamically change the 'FileConnection' property durning runtime in SSIS RE: Question on how to dynamically change the 'FileConnection' property durning runtime in SSIS

  • You don't actually pass them to the SSIS packet from outside. You have the SSIS packet pull the information from those table from inside the package itself. You can use a rowset to read the tables and pass that to a, if I remember correctly, ForEach container which in turn encapsulates all your other SSIS tasks so each task has access to the variables for the file names.