2,773 questions with SQL Server Integration Services tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

SSIS Packages Migration

Hi Can anybody guide on exact steps and share links maybe Youtube links and Microsoft Documentation link for below: SSIS Packages migration from on premises to Azure Sql Managed Instance.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-02-16T17:02:05.1066667+00:00
puri puri 20 Reputation points
commented 2026-02-20T07:33:58.04+00:00
puri puri 20 Reputation points
2 answers

SSIS package fails to read file from UNC path in SQL Server Agent job (Error 0x80004005)

SSIS package fails to read file from UNC path in SQL Server Agent job (Error 0x80004005) We have an SSIS package that reads data from a file on a network share (UNC path). For example, the file is located at \\EXAMPLE_DOMAIN\SharedFolder\file.csv (domain…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-02-18T11:58:59.3166667+00:00
Thanyapong Latthikul 0 Reputation points
answered 2026-02-18T21:42:56.0266667+00:00
Erland Sommarskog 132.4K Reputation points MVP Volunteer Moderator
1 answer

SSIS Package Development in Windows on ARM (MacOS running Parallel)

Hi, Based on https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver17&tabs=vs2026#visual-studio-for-arm64 Although was not able to find SSIS Extension within Visual Studio (2026) but was able to complete…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-02-18T01:32:46.5933333+00:00
Tommy Teoh 0 Reputation points
answered 2026-02-18T01:32:56.6133333+00:00
Q&A Assist
1 answer

We are using windows 2022 server with SQL 2022, the problem is that after sysprep execute ,sql analysis failed with Error:Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change

After upgrade the image to win22 and sql22. Not able to run bam Analysis service getting error Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. ---> Microsoft.AnalysisServices.OperationException: Errors in the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,368 questions
Windows for business | Windows Server | User experience | Other
asked 2024-02-09T08:23:31.9833333+00:00
Kasireddy Alekhya Alekhya (MINDTREE LIMITED) 0 Reputation points Microsoft External Staff
commented 2026-02-16T17:12:27.62+00:00
Stavros Koureas 16 Reputation points
2 answers

SSIS Data Flow has trouble when it has to return many fields

I have an SSIS project that calls stored procedures to create extract files via OLE DB Source & Flat File Destination. The stored procedure returns 150 fields and sometimes a few million records. This causes SSIS & Visual Studio 2019 to take a…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-02-05T20:09:28.96+00:00
Bob-7209 66 Reputation points
edited an answer 2026-02-10T15:13:43.5433333+00:00
Yitzhak Khabinsky 27,096 Reputation points
5 answers

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…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,141 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,368 questions
SQL Server | Other
asked 2023-01-17T12:13:39.11+00:00
Homer Sibayan 366 Reputation points
commented 2026-02-06T05:08:03.4033333+00:00
Shahir Thottathil 1 Reputation point
1 answer One of the answers was accepted by the question author.

SSIS Job Failing Due to MongoDB Driver Dependency Error After MongoDB 8 Upgrade

As part of an ongoing upgrade to MongoDB version 8, we are updating the C# components used to integrate data into MongoDB collections to ensure compatibility with the latest MongoDB driver syntax and APIs. During this upgrade, we are encountering a…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-01-06T15:16:26.63+00:00
Sahar Aitlhou 25 Reputation points
commented 2026-02-05T11:17:43.4566667+00:00
Sahar Aitlhou 25 Reputation points
1 answer

Attunity drivers are failing after OS upgrade to 2022

we have ssis packages where target is sql server 2016 and os 2016. recently we upgraded server os to 2022 but the sql server is still 2016. after upgrade the packages which are using attunity drivers to connect to oracle are failing when we give password…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-01-06T16:10:32.53+00:00
vamsi krishna 0 Reputation points
recommended 2026-02-05T09:12:26.2366667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

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 Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2025-08-13T20:37:02.52+00:00
Greg Troyan 0 Reputation points
recommended 2026-02-05T07:17:25.7733333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 answers

Oracle Connection Manager Type is not available in SSIS 2022

I am using visual studio 2022 along with SSIS, I am not seeing Oracle Connection Manager Type eventhough i have installed the provider (MicrosoftSSISOracleConnector-SQL19-x64.msi) and i am using sql server 2019

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2025-12-24T07:51:13.5366667+00:00
Packiaraj Vairan 0 Reputation points
recommended 2026-02-05T07:12:25.62+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Applying token authentication to read data from a ZenDesk source in a SSIS 2022 package

Hi, I need to maintain an existing SSIS 2022 package that performs an API call to a ZenDesk source by the removed username and password authentication method, changing this authentication type to token one. Unfortunately, I don't know ZenDesk and I have…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-01-17T17:04:53.8533333+00:00
pmscorca 1,052 Reputation points
commented 2026-02-05T06:10:37.6433333+00:00
Lakshmi Narayana Garikapati 825 Reputation points Microsoft External Staff Moderator
3 answers

Choosing Between SQL Server/SSIS 2022 and 2026 — Which Version Is More Stable for Enterprise Use?

Hello, We are a DWH team running our ETL processes using SSIS packages. Our ETL packages are executed on SQL Server via SQL Server Agent jobs, and all ETL development is done in Visual Studio. Our current environment consists of: Windows Server 2019 …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2025-12-23T21:31:26.1866667+00:00
Oktay Bozdemir 66 Reputation points
recommended 2026-02-02T13:18:54.8233333+00:00
Rekha 0 Reputation points Microsoft External Staff Moderator
2 answers

The SQL Server Management studio no longer shows running SSIS packages

Hi everyone, I run a bunch of SSIS packages in a SQL Server Agent job. The packages are deployed as files in the file system. They are executed as SQL Server Agent Service Account. I used to be able to see them under Running Packages. Today, they weren't…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2025-12-19T21:51:23.88+00:00
Igor Gelin 0 Reputation points
commented 2026-02-02T07:50:09.93+00:00
Akhil Gajavelly 1,240 Reputation points Microsoft External Staff Moderator
2 answers

SQL server gave me data baste engine recovery failed AT EXIT CODE -2061893606 ERROR

after downloading and after doing the 4k setup provided here i tried installing but got an error -2061893606 and the Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time:…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-01-14T21:46:11.5966667+00:00
mohmaed ahmed mohamed rahmo 0 Reputation points
commented 2026-02-02T06:51:06.3066667+00:00
Akhil Gajavelly 1,240 Reputation points Microsoft External Staff Moderator
1 answer

Build errors while adding SQL Server 2025 (Version - 17.x)

Hi Team, I have installed SQL Server 2025 (Version 17.0.1000.7), and I am updating a project to add support for SQL Server 2025. For this, I need two processor architecture MSIL assemblies: Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SqlEnum.dll,…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2026-01-12T15:16:17.6266667+00:00
Abhishek Modi (amodi) 20 Reputation points
recommended 2026-02-02T05:56:05.7066667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
7 answers

Error Fix (Database engine service failed in sql server 2022 and 2019)

Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
SQL Server | Other
asked 2022-11-23T00:01:59.227+00:00
Nelson Nwachia 71 Reputation points
edited an answer 2026-01-31T21:51:24.4533333+00:00
Ahmet YILMAZ 0 Reputation points
5 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2025-06-24T18:20:55.04+00:00
Ryan 16 Reputation points
commented 2026-01-27T13:51:31.7933333+00:00
Dinesh Yadlapalli 85 Reputation points Microsoft External Staff Moderator
0 answers

ETL Framework In Production

Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through the Execute Process Task. I am extracting Data from E2 SQL to Azure SQL Server. The connection has already been established. I am building complete…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2025-10-31T06:27:51.5966667+00:00
Uma 511 Reputation points
commented 2026-01-23T09:27:09.1066667+00:00
Akhil Gajavelly 1,240 Reputation points Microsoft External Staff Moderator
2 answers

no puedo descargar sql server me da error

no puedo descargar desde mi tenart las licencias, me da un error que tengo que acturlizar pantalla y no me deja acceder a coger el numero de licencia ni descargar las licencias compradas de sql server

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2025-11-20T15:13:24.2266667+00:00
Francisco Ruiz 0 Reputation points
recommended 2026-01-23T06:37:19.0733333+00:00
Rekha 0 Reputation points Microsoft External Staff Moderator
4 answers

how to modify a DTSX file ?

Good morning, Weeks ago, i created a DTSX file to import data from a flat text file into a SQL table. I'm realizing that i stupidly forgot to check the "empty table before import" box. Is there a way to modify that parameter without…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,776 questions
asked 2025-10-21T09:35:20.2233333+00:00
Stéphane Bergeron 0 Reputation points
recommended 2026-01-22T17:51:49.4933333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator