SSIS

Zip files with SSIS and 7zip

Tutorial to zip files and folders into compressed archives with SSIS and the 7zip software. First, to zip files with SSIS without script, we need to use the 7zip software in addition to the native components. Indeed, several options

Excel Tips

Create and open a new Excel workbook

How to create and open a new Excel workbook? What is the Excel spreadsheet? Excel is a software from the Microsoft Office suite. An Excel file is also called an Excel workbook. Like a traditional physical workbook, it consists