ZIP and UNZIP Files in SSIS | Execute Process Task SSIS
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 [Real Time Practica...
ETL Process Using ForEach Loop Container on Bulk CSV Files
===========================================================
Link : • ETL Process in SSIS [Bulk CSV Files Exampl...
How to Send Mails : Only Mails using Send Mail Task or Script Task
===================================================================
Link 1: • SSIS Send Mail Task Example | Send Mail Ta...
Link 2: • SSIS Script Task Send Emails C# | Script T...
How to Send Mails with File Attachments
========================================
Link : • SSIS Attach Multiple Files in Send Mail Ta...
Subscribe to my channel
=======================
Link : / @theaskguru
Video Link : • ZIP and UNZIP Files in SSIS | Execute Proc...
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