SSIS

Deploy SSIS packages with cmd and the dtutil tool

How to deploy SSIS packages with the cmd command line and the dtutil tool? To deploy SSIS packages with cmd, SQL Server includes the dtutil executable utility that works with cmd command lines, to deploy dtsx files directly with ms-dos. Dtutil.exe is a good choice for scripting and automating the deployment of SSIS projects. It can be run from a command prompt or from

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

Run an SSIS package from the command line using the DTExec utility

Integration Services tutorial to run SSIS packages from the command line using the DTExec utility. The DTEXEC Integration Services tool allows users to run and configure an SSIS package from the command line. Indeed, the Microsoft SQL Server suite includes the DTExec.exe executable. This is a scripting tool for controlling and setting up SSIS packages. It is possible to launch the package execution utility

SSIS

Aggregate data with SSIS and the Aggregate transformation

Aggregate and sum data with SSIS to perform the equivalent of GROUP BY in SQL using the Aggregation Transformation. In an ETL project with SSIS, it is common to aggregate data with SSIS, from a SQL Server table to a higher level, such as data marts. That is, in practice, to calculate the sum of amounts for a given business level. To do this,

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.

SSIS

Import an XML file into a SQL table with SSIS

Tutorial to import an XML file into a SQL Server table with an SSIS package. To import a file in XML format into a SQL Server table with SSIS, it is necessary to provide the schema in XSD format that represents the structure of the file. In this case, the XSD file is automatically generated by Visual Studio and Integration Services. This tutorial explains

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 Excel cells with SSIS into a SQL table

How do I import a range of specific Excel cells into a SQL Server table with SSIS? When importing data from an XLSX file into a SQL table, it is possible to import specific Excel cells with the SSIS options. The range will necessarily be contiguous, in other words, the Excel cells to be loaded are side by side. However, to load multiple non-contiguous

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

SSIS connection string to load Excel files

How to build an SSIS connection string to connect to Excel files and load data into a database? To connect, read and load data from Excel files with SSIS, it is necessary to build an OLEDB connection string. There are several ways to do this, a connection with the Excel Connection component of SSIS, using an ADO driver, or using an OLEDB connection. Syntax