MS-DOS

Copy files recursively with cmd and the xcopy command

To copy a single file or multiple files recursively with the cmd command prompt, use the xcopy command and the recursive options. The xcopy command is very similar to the copy command but it handles recursion and has many other options mainly related to recursion. How to recursively copy files and folders with windows cmd? Indeed, when copying a large number of files and

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

SSIS

SSIS Merge JOIN using multiple tables

Tutorial to use the SSIS Merge Join transformation with two SQL Server tables into one target table. Use the Merge Join with the SSIS component allows you to perform a join and merge two or more data sources based on a common key. In other words, the SSIS Merge Join component allows you to merge different heterogeneous or non-heterogeneous sources into one, such as

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 the 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