Read Source and Destination Path of Files from Excel File and Move them in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

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

  1. How to read the records from Excel file and save into Record Set Destination( Object Type Variable)
  2. How to Loop through records from Object Type variable by using For-each Loop Container
  3. Use File System Task to move the file from Input Folder to Destination Folder

Read File Source and Destination Path from Excel and Move them to Destination Folder in SSIS Package - SSIS Tutorial



    Related Posts/Videos on File System Task  


3 comments:

  1. Informative stuff. Actually, I'm also a student and find out the solved or answers to my syllabus questions & landed here. I met a literary girl who did not want to have anything to do with a person with such a narrow literary, if not intellectual, radius. As you might guess, I went home and sat down to read the book of lineserved.com with special attention. Its a fact you have also shared an enjoyable and informative piece of content here. Anyways, thanks for sharing the nice piece of stuff with us.

    ReplyDelete
  2. Thanks so much for sharing this awesome info! I am looking forward to see more postsby you! upload files free

    ReplyDelete
  3. Concrete surfaces can be etched or engraved for added visual interest.
    Concrete and Asphalt Paving

    ReplyDelete