use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerator in ssis

Question

Hello There,

I am trying to find the use case scenario for when to use

1. Name and Extension
2. Fully Qualified
3. Name Only

while importing flat-file type files from source in SSIS.

Would anyone help me understand the use case scenario for each of the 'retrieve file name' type.

Thank you for giving your valuable time!

Answer 1

Hi @ArunRaaman ,

1.Name and Extension: If you select this option, the Foreach loop will store File name and extension in the variable. For example, Employee1.txt

2.Name Only: If you choose this option, the Foreach loop will store Filename in the variable. For instance, Employee1

3.Fully Qualified: If you select this option, the Foreach loop stores Path, Filename, and extension in the variable. For example, E:\Folder Name\Employee1.txt.

Here is a sample you can take a reference to.

ssis-foreach-loop-file-enumerator

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.