The current solution GUI for adding SSIS packages is limited to adding a single package at a time. For real-world projects with dozens or hundreds of packages, the effort involved in adding each package individually is onerous.
I suggest that the UI be updated to include the following options for adding packages from the file system:
- Add a single package by selecting a DTSX file (feature already in place)
- Add a group of packages by selecting a DTPROJ file - all packages in the selected project will be added
- Add a group of packages by selecting a SLN file - all packages in all projects in the selected solution will be added
- Add a group of packages by selecting a folder - all packages in the selected folder will be added
- Add a group of packages by selecting a folder - all packages in the selected folder and all subfolders will be added
Having this functionality in place would greatly lower the up-front cost of using this tool to document the BI projects that need it the most.