SSIS Package for creation of Excel file with files and Folder names in any drive and folder
I just want to create SSIS Package for creation of Excel file with files and folder/sub-folder names in any drive and folder. I mean to say if there is a folder say C:\Temp in my computer then I want to make a list of all folders in excel file. Then I want to rename the file 'Inventory.zip' that is present in the location say C:\Temp\SSISTest\Inventory.zip If 'Inventory.zip' is present at multiple locations in different folders i.e more thatn one folder like C:\Temp\OrdinaryPackage\Inventory.zip then I also want to rename that file 'Inventory.zip' irrespective of it's location in any sub-folder. Can anybody help me with this as early as possible? Thanks in Advance!!!