SSIS Find and Replace on TXT/XML

Ross Turner
Ross Turner used Ask the Experts™
Hi EE,

i need some help with Developing a SSIS package, the simple idea is to open a txt / or xml file and do a find and replace on a specific string and then save said file.

i seem to have hit a mental block and suggestion or ideas would be fantastic.

Ideally i would like a solution that would keep the package self contained but i'm open to using external factors.. e.g cmd/batch script to achieve the end result.

i'm building the package in Visual Studio 2010.

Many thanks

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial