I have around 10 solutions .sln, each of them with multiple packages in it.
I would like to be able to get:
- solution name
- package name
- mapping between the source and target columns
- source and target table(s)
- source connection or source DB
Would that be possible by parsing the .dtsx file? I understand I can save it to an .xml file.
For now, what I did was to configure the SQL Server Profiler and to run all packages to retrieve the current SQL queries, dumping them in a table and parsing them directly in SQL Server.
I wonder if there is not a better solution using an external tool (like biml) or by parsing the files directly.
Any suggestions are appreciated