So I have a folder which contains 23 files which were generated from a SSIS package (SQL data converted to XML files).
These files are .xml extension and named like Individual_1.xml, Individual_2.xml, Individual_3.xml, Individual_4.xml and so on…
Each file is around 500-800 mbs.
In these files there is some un-wanted text that I want to replace.
Originally I did this using a powershell query with in the SSIS package but for some reason its not working anymore.
The file size is too big may be and it takes forever to load or open and sometimes it gives error out of memory exception and sometimes it just keeps loading.
Can anyone suggest any other way I can achieve this?
When I first wrote this code and executed it, it worked without any issue.
The un-wanted text was removed and file was saved just the way I wanted it.
But now when I run it, it doesnt work anymore.
Only thing changed between the first time and now is I reinstalled my OS on the laptop.
Either it just keeps running and no error message appears or sometimes it just show out of memory exception error.