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 are available to the developer for compressing files. For example, it is useful to reduce the size of folders containing text, Excel, or database files.

MS-DOS

Copy files with cmd command prompt in Windows 10

How to copy files with cmd using the Windows 10 command prompt? To copy files with cmd to other Windows folders, use a script with copy in the command prompt. Two main options allow users to copy files in Windows batch scripts. The options are the copy and the xcopy commands. Of course, it is always possible to copy files and folders using the

SSIS

Export SQL Server data into a CSV file with SSIS

Export data from a SQL Server table to a text file in CSV format with an SSIS package. This tutorial explains how to export the SQL Server data into a CSV file with SSIS. The export here is in CSV format, and SSIS offers many other options. SSIS has been one of the leaders in the field of ETL and data integration for many

SSIS

Import an Excel file into a SQL table with SSIS

Import an Excel file into a SQL Server table with an SSIS package. Step by step tutorial to import data from an Excel file (xslx) into a SQL Server table with an SSIS package. Here, the target is a SQL Server database. From Visual Studio, use the native Excel component available in the SSIS data stream source connections. Load Excel files into SQL Server

SSIS

Import multiple CSV text files into a SQL table with SSIS

Import multiple csv text files into a SQL Server table with an SSIS dynamic loop. This tutorial explains how to import multiple CSV text files into a SQL table with a single package that uses a dynamic loop to detect the files. To start with, all text files (.txt, .csv, etc…) must be in the same folder. This automatic integration uses dynamic variables and

SSIS

Import a CSV file into SQL Server with SSIS

Step by step tutorial to import a csv flat file into a SQL Server table with SSIS. It is possible to import a CSV file into a database with the SQL Server BI suite and SSIS in particular. Often, data integration projects require to load data from flat files or external databases. Files structures are either CSV, TXT, RAW files or other less common

Powershell

Copy files with PowerShell and the Copy-Item command

How to copy Windows files to another folder with PowerShell? There are several efficient options to copy Windows files with the PowerShell command prompt. In PowerShell scripting, use the Copy-Items command in a Windows PowerShell prompt. It is also possible to copy from the GUI, but this option is very manual. Indeed, it is always possible to copy files and folders using the interface

SSMS

Import data from Excel to SQL Server with SSMS

In this SQL Server tutorial, here is how to Import data from an Excel file to a database, with the SQL Server wizard, without SQL code. To do this, use the Data Import Wizard from SQL Server Management Studio. In this example, here is how to import data from a source Excel file to a SQL Server target table. To Import an Excel file

SQL Server DB

Drop a SQL Server database with a script

How to delete a SQL Server database with a script? And delete all associated files? These files are the .mdf, .ndf, .ldf files and also the .bak backup files. Use the SQL Server Drop database command as below. With a check beforehand to avoid errors. It runs the command only if the SQL Server database exists on the given server and instance. Create a

Excel Tips

Create an Excel table

Create an Excel table from a data area. How to create an Excel table and sort, format and filter its columns? Then filter the data? First create the required rows and columns. Fill the table with data and turn it into a table with headers. In the form of a table, it is possible to sort and filter the data easily. An Excel table