Email Merg ?

What I have is a large email message template where I'd like to replace ||Customer|| with the results of another calculation in my transformation. What is the best approach for this.




I tried using this formula. But I keep getting errors.

Hi Dean.

Using calculation in the most of the cases is the slowest option.
You can use "In Place Replace" Transformation instead.
See the pictures below

I can upload some screenshots if you like. But this looks like I can only utilize one field. I need to take one field that I get from an email template and replace ||Customer|| from a customer database which I do a lookup to get.

Click plus on "In Place Replace" function and you will get more fields to use

That actually didn't work for either. It's like the data I put in the template is too large. We have opted to say," Dear Valued Customer"


None the less, it is nothing that I am interested. It is a case I want to take one database field (text) and replace it with another text field. I know what part of the first text field I want to replace.


This is extremely easy with SSIS. I can create a video for that if it would help explain it better.

I am sorry we did not know that template is that big.
There is an alternative solution.
Create two files before and after customer name.
use get file content function to load data from those files.
than Join them together.
this is leterally 2 minutes job.
we are happy to connect remotely and assist.