I have a requirement in SSIS to pick up all the files in a folder that were modified in the last 24 hours and then ship those to an FTP location.
Any suggestions are greatly accepted.
Create an object variable and a string variable
Use a script task to fill a datatable with the files and set the object variable to the datatabase.
Use a ForEachLoop and iterate the dt using the ado,net dataset set to the object variable and setting the string variable to the path. in the ForeachLoop use a script task to set a file connection managers ConnectionString to the file path in the string variable and use an FTP task to transfer the file.