July 20, 2022 at 5:17 am
Hi everyone,
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.
Can anyone suggest any other way I can achieve this?
What I want is that when I run the ssis package and files are generated, in the last step all files are edited one by one and remove/replace the text and save the file....
July 20, 2022 at 7:42 am
Fixing your PoSh script is probably a good way to proceed.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply