question

If you mean the columns are delimited by 1 particular character, you can set that when you configure your flat file connection manager. You can also set any row delimiter there. The "Columns" tab of the connection editor gives you both options. You can put any character or set of characters for each delimiter. If you do not know the delimiter in advance (but can determine it during runtime), you could try reading all data in each row as a single large string column. Then you can parse the data using a script transformation component to split it into columns. That is a pretty simple task using the C# string Split method. Once the string is split, you can perform whatever validation or other operations you want on each element and then return them as columns in the output to be stored as columns in your destination.