Archives des SSIS

Create a new SSIS project with Visual Studio 2019

26 August 2022

How to create a new SSIS project and solution with Visual Studio 2019? To develop SSIS packages, i.e., SQL Server Integration Services, you need an integrated development environment, called IDE. Visual Studio is the development environment provided by Microsoft. To create a new solution, a new project and a new SSIS package with VS2019, you need first to install Visual Studio 2019 and then …

Uninstall the SSIS projects from Visual Studio 2019

24 August 2022

How to uninstall the SSIS (SQL Server Integration Services Projects) from Visual Studio 2019? Microsoft tutorial that explains how to uninstall SSIS, i.e., the additional extension called SQL Server Integration Services Projects from Visual Studio 2019 and therefore from Windows 10. SSIS services and SSIS projects extension are two different things. The SSIS projects extension is an add-on that allows you to create packages …

Install SSIS projects in Visual Studio 2019

23 August 2022

How to install the SQL Server Integration Services (SSIS) projects in Visual Studio 2019? This is a Microsoft tutorial on installing the SQL Server Integration Services Projects extension on Visual Studio 2019. We assume that Visual Studio 2019 is already installed on your computer, which is using for example the Windows 10 operating system. With Visual Studio 2017, SSIS, SSAS and SSRS projects were …

Manage Excel data type with SSIS

31 March 2022

How to manage Excel column data type with SSIS with the sampling registry key? The integration of Excel files via SSIS requires you to freeze the data type in the OLEDB component. This is because the Excel data type is determined in SSIS by sampling the first 8 rows of the default column in the OLEDB component for Excel sources. To manage Excel data …