I have done a lot of searching and still have found no answers to my core question. I can identify pretty much any other connection manager and their details for SQL Server, Excel, SharePoint, other DBMS software but have not been unable to find flat file/text file information (File location or destination) other than what format (Delimited/Ragged Right/etc) they are. We have over 1,000 packages moving data around and NotePad++ shows too many duplicates.
We have migrated all network and servers to a new network (Acquisition) and are having issues with our Jobs/SSIS Packages connecting to shares where files that are being placed by the FTP team for incoming and us writing outgoing files. My task is to identify all of the packages that read/write files to the network shares and decide how to best mitigate this issue.
Any ideas on a column in the SSISDB or MSDB data databases that might hold this information?