SSIS||How to unzip the folder and copy the files from one folder to other folder?
Please check the below code in Script Task:
string zipfullpath = Dts.Variables["User::ZipFilePath"].Value.ToString();
string inputfolder = Dts.Variables["$Package::DestFolder"].Value.ToString();
using (ZipArchive arch = ZipFile.OpenRead(zipfullpath))
{
foreach(ZipArchiveEntry entry in arch.Entries)
{
entry.ExtractToFile(Path.Combine(inputfolder, entry.FullName));
}
}
File.Delete(zipfullpath);
Watch video SSIS||How to unzip the folder and copy the files from one folder to other folder? online without registration, duration hours minute second in high quality. This video was added by user LearnSQLtoSSIS 06 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 339 once and liked it 4 people.