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 ...

Please provide some sample data, showing what your source looks like and what you would like to see in your destination. Your explanation is confusing.

As long as the server running your packages has SSIS installed, you can get data from wherever you want.

rocky_498 (10/15/2010)

---

Thanks for your reply. My target table has field called "P_id" and its "Primary key" and requirement is 'P_id" always auto generate i.e "cba-000001", "cba-000002".

* In target table...

I presume you want help identifying why this error is occurring and are not just telling everyone your plight for information purposes.

Are you doing any string manipulation (using functions such...