C# SSIS Create zip file from various folders according to folder names
Budget: $10 – $30 USD
I want to create a zip file that will have:
C:\document\Customer\20220105\abc.txt
C:\document\Customer\20220119\abc.txt
C:\document\Customer\20220215\abc.txt
Results should be :
C:\document\Customer\2022 01.Zip\20220105\abc.txt
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""\20220119\abc.txt (in same zip folder)
C:\document\Customer\2022 02.Zip\20220215\abc.txt
Currently I am only able to get to one of the folder and not loop through the others not sure what is wrong.
I have a foreach container with parameter:
SourceDir=C:\document\Customer\
FolderDir=C:\document\Customer\20220105\
I have attached the script
C:\document\Customer\20220105\abc.txt
C:\document\Customer\20220119\abc.txt
C:\document\Customer\20220215\abc.txt
Results should be :
C:\document\Customer\2022 01.Zip\20220105\abc.txt
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""\20220119\abc.txt (in same zip folder)
C:\document\Customer\2022 02.Zip\20220215\abc.txt
Currently I am only able to get to one of the folder and not loop through the others not sure what is wrong.
I have a foreach container with parameter:
SourceDir=C:\document\Customer\
FolderDir=C:\document\Customer\20220105\
I have attached the script
Related categories:
.NET
C# Programming
ASP.NET
Microsoft SQL Server
SSIS (SQL Server Integration Services)