Scenario:Let's suppose we have a lot of files in our Folder or even sub folder or different folders. Our Team review each of them. Once they are done with Review they put the Source File path and Destination File Path where they file should move. We need to Create an SSIS Package that will read the List of Files from Excel file and then move them to required folder.
What we will learn in this video
- How to read the records from Excel file and save into Record Set Destination( Object Type Variable)
- How to Loop through records from Object Type variable by using For-each Loop Container
- Use File System Task to move the file from Input Folder to Destination Folder