Video : ZIP and UNZIP Files in SSIS | Execute Process Task SSIS
Complete step By Step ETL Process with Full Explanation
=======================================================
Link : • ETL Process using SSIS...
ETL Process Using ForEach Loop Container on Bulk CSV Files
===========================================================
Link : • ETL Process in SSIS [B...
How to Send Mails : Only Mails using Send Mail Task or Script Task
===================================================================
Link 1: • SSIS Send Mail Task Ex...
Link 2: • SSIS Script Task Send ...
How to Send Mails with File Attachments
========================================
Link : • SSIS Attach Multiple F...
Subscribe to my channel
=======================
Link : / @gurunathad13
Video Link : • ZIP and UNZIP Files in...
In this video we have discussed with a complete real time project based scenario how to do zip and unzip files in ssis package using execute process task. We also created dynamic folder using file system task and extracted or unzipped that zip files into that directory and once we had that directory with source data files on the same we did ETL process step by step using ForEach Loop container.
Once ETL is done on a particular file on that file we renamed it using file system task and finally on ETL done files again added to ZIP file using execute process task.
Finally after creating ZIP file we deleted old ZIP file and Source Directory using File System Task.
#ZIPUNZIPSSIS
#ZIPUNZIPExecuteProcessTask
#ExecuteProcessTask
#FileSystemTask
#RealProjectSSIS
17 май 2021