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
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
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
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 Analysis Services
Windows for business | Windows Server | User experience | Other
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
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 Integration Services
SQL Server Analysis Services
SQL Server | Other
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
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
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
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
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
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
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 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
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
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 | Other
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
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
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
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…