I've writing a ssis package. I've got a data flow task which is basically an
xml transformation, I read an xml and then insert the data.

I am trying now to put this data flow task within a look so I can read many
files one after the other. I've done exactly the same thing with text files
with no problems.

It seems that the fact that I've an xml as the source make it impossible to
process files in a loop. I open the xml connection file then create the
expression as normal. But when I run the package it's still looking for the
old file name I've defined first. It doesn't become dynamic.

In contrast when I do exactly the same with a normal flat file source and
add the expression then the file name disappears if you do Edit connection.

Do I need to do something special to process xml files in a loop? Thanks.

Panos.