I have around 200 SSIS packages, in which I want to make few edits.
I am trying to check if Powershell can solve this issue. I have a specific location in which all my SSIS packages are kept. In each of the SSIS package, there is a GetConnection method. Inside the method , I want to find the first instance of the text GetConnection = strConnection , and add another connection string property before it and save the file.
This process should be repeated for all the files. How to achieve this in Powershell ?