Archives des SSIS

Deploy SSIS packages with cmd and the dtutil tool

2 November 2022

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 Merge JOIN using multiple tables

27 October 2022

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 …

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

24 October 2022

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 …

Aggregate data with SSIS and the Aggregate transformation

19 October 2022

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, …

Zip files with SSIS and 7zip

17 October 2022

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. …

Import an XML file into a SQL table with SSIS

13 October 2022

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 …

Export SQL Server data into a CSV file with SSIS

9 September 2022

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 …

Import Excel cells with SSIS into a SQL table

7 September 2022

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 …

Import an Excel file into a SQL table with SSIS

6 September 2022

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 connection string to load Excel files

5 September 2022

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 …

Ads Blocker Detected!!!