SSIS Tutorial Part 98-Get File Names from FTP Server and Save to SQL Server Table in SSIS Package HD

FTP Task in SSIS Video Scenario: We have different files on FTP Server, we want to get the names of all the files from FTP Server folder and save to our SQL Server Table for Audit Purpose. By doing that multiple times we can get the snapshot of all the files available on FTP Server Folder. This can be very useful when we are looking for some total files to be there before we start process etc. we will learn following items in this video How to Create an SSIS Package from basics How to create FTP Connection in SSIS Package How to Create ADO.Net Connection in SSIS Package to Connect to Database How to Create variable for FTP Folder Name and pass to Script Task Write Script by using VB.Net in Script Task to Get the List of Files from a Remote FTP Folder and insert the file names to SQL Server Table. How to change the value of Variable to loop through different folder to extract file name without make any other change in our SSIS Package Link to the blog post for this video http://sqlage.blogspot.com/2015/05/get-file-names-from-ftp-server-and-save.html Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12/ssis-videos.html