24 Foreach loop Item Enumerator in SSIS Example

[@viswanathponne]

Very clear explanation bro. you are doing good job

[@learnssis]

Thank you Viawanath for your comment.

[@MVinodKumar-tt1tu]

Hello Sir, 1st:- Is it Mandatory to give values for Month and FolderPath Variables while creating variables?. Like anyhow we configured foreach loop with values and mapped with variable Month. For Folderpath we are giving expression which uses "@[User::ParentFolderPath]+ (DT_WSTR,12)YEAR( GETDATE() )+@[User::Month]" as it uses parentfolderpath in which we are dynamically creating folders. So is it necessary to give inital values to the variables or not sir? 2nd:- And what are the Expression in the File System Task Editor what scenario can we use it. And the same expression we used for dynamic file path in the variable expression. can't we use this expression in the expression of file system task?

[@learnssis]

1st: No need to give value to FolderPath and Month. 2nd: You can check the properties in the Expression in the File System Task. Whatever properties are there if you want to set them dynamically at run time from an SSIS variable then you can use the expression option otherwise no need to use that.

[@antarabhattacharjee3294]

what are the most commonly used enumerators?

[@learnssis]

Most commonly used ones are File Enumerator and Ado Enumerator. Thanks.

[@antarabhattacharjee3294]

@@learnssis Thank you so much.

[@krishnachaitanyareddy2781]

can you give better example. I didn't understand the variables. ParentFolder and FolderPath. with one variable can we manager with folderpath.