question

Scott 1 1 avatar image
Scott 1 1 asked

Find all Text File connection manager in SSISDB

Hello,

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?

Thanks,

Scott

ssissql server 2016msdbmetadataconnection string
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.