How to search folder in the file system and move it to the destination file system using ssis?
I have some tables in SQL Server database, in each table there is a column that contain a ID number. For some each specific ID number application create a folder in the file system, folder name is same as ID number, folder contain many sub-folder and files with different name. I have to select ID numbers from tables and need to find those ID number in file system as a folder name, if any found then move the folder and its all contains to the destination file system if the folder do not exist in the destination. I may need your help to do this using ssis.