What I am unsure about is whether Excel interprets the string "20%" correctly as a numeric percentage and does the formatting for you.

If it does, you should add a derived...

Sorry - I'm in the middle of a course...

Why are you doing this? Is it because you want a numeric value formatted as % in Excel?

It's because they don't know how to use Access and Notepad is ungainly to use - understandable, I think. But we as IT people are in a position to educate.

Craig Farrell offered all the value I need with his public flogging. Made me laugh with a hangover this morning, and that's quite a feat 🙂

I cannot help you because I still do not understand, I'm sorry.

You started the thread with a source table containing two fields:

Source table field (NAMEONE, NAMETWO) MAPPING WITH ONE destination...

You have managed to provide sample data without illuminating things much.

If your sample data is really

COLEMAN JEFFREY C & JENNIFER C/O J COLEMAN

how do you know where Nameone ends and...

Can you give maybe two or three examples of what NAMEONE and NAMETWO might contain and what you would like NAME to contain for each?

Regarding NameType - does that mean...

Can you side-step the problem by replacing commas in your header variables with some other character before they are output? Or by using a different column delimiter everywhere else (eg...

Are you saying that your script task does not put the characters there but that something else does?

da-zero (10/20/2010)

Relax. The week is almost in the middle. It is almost weekend...

Modify your script task slightly to not insert the final <CR><LF>? Or is that too obvious?

You cannot control mappings dynamically at run time in SSIS, using the built-in components.

If you have the money and inclination, this may work for you (I have not tried it...

Anyone else following this?

Your data is nowhere to be seen ...