Sorry You cannot understand my problem.

I have a large flat file source and i want to transfer data into multiple destination flat files.But destination file names come with in the text of each row data in the source file.

So I read the data from source file and called a script component which identified the file name and setting the variable e.g "User::CurrentRegion" which is the part of conectionStringExpression Like this

"C:\\test\\region_" +@[User::CurrentRegion] + ".txt"

But when i execute the SSIS is setting up the values of the variable but it is not setting the expression of connection string of Destination File.

I cannot find out the actual Reason for this problem.

So at the end i brief my problem again i.e

i read a row from source file and put into his destination file without using the condional splitting.