SQL Server Integration Services

WCF EndpointNotFoundException when connecting to

System.ServiceModel.EndpointNotFoundException: Could not connect to the remote endpoint 18775299031 Server stack trace: at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at…

Error execute a SSIS Packed with SQL Agent

Hello, we have a very strange problem when executing an SSIS package with the SQL Agent. The package has the following tasks for an Excel file: 1. Check file in the source path. 2. Copy file to the destination path. 3. Open file in the destination…

Unable to install SQL server

How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..

Hi Experts, For the first time, we install New SQL Failover clustering on primary host and it success, however when we tried to install now the SQL on the secondary host as Add node SQL failover cluster, we encountered an error at the beginning of the…

SSIS (DTExec.exe) Complus (COM+) Error with Large Excel Files Since August 2025 Patches

Our SSIS process has been running reliably for over two years without any issues. However, starting in August 2025, we began encountering a consistent crash when loading large Excel (.xlsx) files using the Microsoft.ACE.OLEDB.16.0 driver. The crash…

VS 19, SSIS project, getting and error "The specified provider is not supported. Please choose different provider in connection manager" when choosing OLEDB as the connection type

Using Visual Studio 19 on new laptop. Have installed the SSIS template. I also have SSMS 19 installed. I create a new project and try and create a new Connection Manager. I select OLEDB and click Add... On the next screen to configure the OLE DB I select…

importing excel using Import or export

my imput and export data doesn't have the excel imput

msodbcsql RHEL 10 support

Hello, is there a release date msodbcsql17 or msodbcsql18 with RHEL 10 support? RHEL 10 repository already exist https://packages.microsoft.com/rhel/10/prod/ but there is only azure-cli, but no msodbcsql stuff.

Unexpected API Response Error 16464 — Need Clarification

System.InvalidOperationException: Operation failed with error code <error_code_164640> at MyApp.Controllers.PaymentController.ProcessRequest() in /src/Controllers/PaymentController.cs:line 668 at MyApp.Program.Main(String[] args) in…

SSIS package works in Visual Studio 2022 but not from command line?

I have a snippet of a workload that involves importing data from a CSV file into a MySQL database via ODBC. When I run it within Visual Studio it works just fine but when I run it via DTexec.exe (64-bit) it fails with the following errors: Description:…

SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…

High Memory Usage in SSISDB Related to MEMORYCLERK_SQLBUFFERPOOL

We are using SQL Server 2019. On this server, several content databases (used for reporting purposes) and an active SSISDB are running. The entire system is hosted on a single server where SQL Server 2019 is installed. Occasionally, memory usage on the…

SQL Server 2019 SSISDB's High Memory Usage

We are using SQL Server 2019 and SSIS on a single server, which runs nightly ETL jobs using SSIS as the ETL tool. Each night, when the ETL processes begin, SSISDB’s memory usage increases significantly. However, even during the day—when no ETL jobs are…

Problem creating file exactly as I want it

Hi everybody, I'm trying to generate a simple text file with added footer. Here is what I managed to generate now which is not what I…

SSIS: Create output file with specific name and a footer

Good day, I have the following requirements - create a daily file with the filename in the pipe delimited format using name like 'PDMAutomation_yyyy_mm_dd.txt. Also this file needs to have a footer, e.g. source|request_type|change_type|Other…

SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services

Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…

SSIS Package Execution Error - The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered

Hello Community, I have been getting this error message every time I run my saved SSIS package. And even though I have looked up this error message across the web, the solutions have not seemed to work. To provide the background information with the…

How do I condition a task based on a parameter

I have an SSIS package that has a boolean parameter called IsProd. I want the first task in the package to only run if IsProd is true. How do I set this for the first task? How would I do this if the package only has one task and I cannot set from and…

how to fix issue om.microsoft.sqlserver.jdbc.TDSChannel enableSSL WARNING: TDSChannel ( ConnectionID:1 TransactionID:0x0000000000000000) SSL handshake failed: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

Previously, I used JDK 1.6.0, but due to company requirements, I had to switch to OpenJDK 8u422 in Eclipse. After making the change, I received warnings, and some functions also showed warnings when running. There are a few functions that do not display…

How to fix - Excel Connection Manager fails in SSIS

Hi there! I am trying to ingest data from an Excel file (.xlsx) using SQL Server Integration Services (SSIS) through Visual Studio. The versions/specs that I am running are: Microsoft Visual Studio 2022 - 64 bit version 4.8.04084 SQL Server Data…