I am currently exporting data from a database into XML files. This works very well. Depending on the amount of data, an XML file consists of only one dataset or hundreds. This process is triggered daily. Now the datasets should have a property like "FileNo" which should be zero at the beginning and then always increased by the value one. Now I have seen that there are foreach-containers and for-containers in SSIS. Unfortunately I am afraid that the use of such a container gives all datasets the same "FileNo" per day and so they are not all are raised correctly. Besides, I do not know if it is possible in SSIS to cache the last value of the variable "FileNo" somewhere, so that the next higher value of "FileNo" can be used on the next day and not to start again with zero...

Do you have an idea how to count such a variable and store it somewhere, to call it on the next day again? So in the end it should look like this:

Thank you for your help.