Flatfile Destination Expression Problems

Hi:

Am trying to write SQL data to multiple flat files.

I use a For Each loop,

store field Values in variables

construct a fileName(variable as expression) for each row,

then create a text file for each row in resultset, (Filesystem task)

and then try to fill each file from a SQL Source to a Flatfile Destination.

Destination.connectionString=Filename.



Works ok for creation of Text Files, so I know my fileName variable is getting evaluated for each iteration.

But the flat file connection manager is stuck and evaluates to the static part of my expression.



What am I doing wrong?

TIA

Kar