Hello,

Yes, you can achieve this easily using a Foreach Loop and an ADO.NET connection.

1) Drag a Foreach Loop on your Control Flow.

2) Click once on your Foreach Loop and create...

Use the variable which is used by your for each loop container in a Derived Column Transformation.

Set Derived Column Name to Clientname, leave Derived Column as <add as new column>...

There are different options to solve this problem.

The easiest would be to change the text qualifier to None in your flat file Connection Manager and use a derived column or...