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

10,000, I think you'll find sir 🙂

rocky_498 (10/14/2010)

---

Hi,

Can anyone help me? I have created a table and with a primary key called "ID".

However, I want the "ID" be auto increment as well.

Here is...

Afternoon here and I'm fully caffeine'd-up 🙂