we were working with SSIS and using a foreach loop container. Just like this -
My question is about the variables that can be used. If you look at the 'Deleting the files' section in that link, there will be a screen shot of editor where we can manage the variables. We have our variable defined like this @[User::TheseFiles] is mapped to c:\test_files. When we put that variable in the 'Enumerator configuration' field and run our script, it works just fine but the variable (@[User::TheseFiles]) which was in the 'Enumerator configuration' field has now been replaced with its value (c:\test_files).
Is there a way to retain the variable name in the 'Enumerator configuration' field and not have it be replaced with the value of the variable?
My question is about the variables that can be used. If you look at the 'Deleting the files' section in that link, there will be a screen shot of editor where we can manage the variables. We have our variable defined like this @[User::TheseFiles] is mapped to c:\test_files. When we put that variable in the 'Enumerator configuration' field and run our script, it works just fine but the variable (@[User::TheseFiles]) which was in the 'Enumerator configuration' field has now been replaced with its value (c:\test_files).
Is there a way to retain the variable name in the 'Enumerator configuration' field and not have it be replaced with the value of the variable?