157 How to compress a file without any third party software in ssis

How to compress a file without any third party software in ssis
Download files and scripts: drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
How to compress a file without any third party software in ssis
Zipping a file in SSIS
how to zip multiple files in ssis
Can SSIS zip files?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@romariovargas2586]

Hello teacher, sorry for the inconvenience but I have Visual 2022 installed with SSIS on Windows 10 Pro but I cannot view the count of records that pass between objects and when I click on display data it only omits and is passed but the flow has no error at the start of data origin and the end appear in chechlist and the intermediate objects appear in amber, it is as if I were thinking (I have enough memory), what could be happening, can you please guide me, I have been looking for the solution for days. Thank you

[@keithmellor9238]

Thank you for the clear tutorial, this is very useful for my work project. Can you please tell me how i could add adapt the script to add a dynamic timestamp to the zip file in the format YYYYMMDDHH24MISS ? With it being a C# script im unfamiliar with this syntax. Many Thanks in advance :-)

[@learnssis]

this is the code to zip a single file. string currentdatetime = DateTime.Now.ToString("yyyyMMddHHmmss"); string LogFolder = @"D:\Files\Logs"; // string sourceDirectory = @"D:\Files\Apple"; string zipFilePath = @"D:\Files\Data.zip"; // string zipFilePath_Folder = @"D:\Files\Apple.zip"; try { // ZipFile.CreateFromDirectory(sourceDirectory, zipFilePath_Folder); string formattedDate = DateTime.Now.ToString("yyyyMMddHHmmss"); string newZipFilePath = Path.Combine(Path.GetDirectoryName(zipFilePath), Path.GetFileNameWithoutExtension(zipFilePath) + "_" + formattedDate + Path.GetExtension(zipFilePath)); string sourceFilePath = @"D:\Files\Email.csv"; using (FileStream zipToCreate = new FileStream(newZipFilePath, FileMode.Create)) { using (ZipArchive archive = new ZipArchive(zipToCreate, ZipArchiveMode.Create)) { archive.CreateEntryFromFile(sourceFilePath, Path.GetFileName(sourceFilePath)); } } } catch (Exception exception) { using (StreamWriter sw = File.CreateText(LogFolder + "\\" + "ErrorLog_" + currentdatetime + ".log")) { sw.WriteLine(exception.ToString()); } }

[@alahariprasannakeerthi7743]

Hi can you please make a video how to convert the.csv into xl files in visual studio 2008

[@learnssis]

Just take the flat file source and browse the csv file, it can read data from csv file and then using excel destination to write data to excel file. This is straightforward. kzbin.info/www/bejne/bmm7eWxsnLh0Zrc