A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Can't deploy SSIS package - An error occurred during decryption. (Microsoft SQL Server, Error: 15466)
When trying to deploy an SSIS .dtsx package, I get the below error message: --------------------------------------------------------------------------------------------------- TITLE: SQL Server Integration Services …
SQL Server Integration Services
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SSIS Oracle Source - DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
Hi All, I'm using Visual Studio 2019 to get data from a Oracle Database and transfer it to a SQL 2019 database. I'm using Oracle connection (Connection Manager for Oracle Connections) for my source and an OLE DB connection for my SQL 2019 database.…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Need help on parameterization of Integration Runtime and Azure Key vault Secrets on link service in Azure Data Factory pipeline
Hi, I have to migrate 90 clients database from Azure Managed Instances databases to Azure VM Data Servers. For the above requirement, I have created the below resources * 90 Azure Data Factory Pipelines * 90 self-hosted integration runtime as each…
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
Azure Database Migration Service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Reading data from ERP E2 and Push to Azure SQL.
Hello, May someone please help me how can I pull data from ERP named as E2. E2 is using SQL Server. Looking for detailed steps of connecting to E2 System. I am planning to use python scripting as it is open source. Do I need to Install any driver. what…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
copy activity from sql server to adls gen2 parquet format , getting below error
ErrorCode=Unknown,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=An unknown error occurred.,Source=Microsoft.DataTransfer.Common,''Type=JNI.JavaExceptionCheckException,Message=Exception of type…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
AI answer
Unable to open exsiting packages in visual studio 2026
I m not able to open exsiting packages in visual studio 2026 i have installed everything
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Loading files ( CSV different structures) using SSIS
Hi, I have 5 different files with different columns and I would like to load them into SQL tables via SSIS. I have the option of writing 5 dataflow tasks. however is it possible to load them dynamically with just 1 dataflowtask
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
C# script task error(binary code for the script is not found)
Our SSIS package is successfully running in Production environment. We received a request to add some extractions in the same package and the existing package has many C# script task. Now we are trying to modify and runs the package the package in…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
AI answer
i have updated visual studio ,after updating all my packages in project are not opening
i have updated visual studio ,after updating all my packages in project are not opening
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQLLOCAL.exe cannot be found #sql
Resolving "SqlLocalDB.exe Not Found I can't find it. #SQL
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQL SERVER SUPPORT
How can I get sql server support from microsoft?
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Support for Entra User Identity Passthrough to Remote MCP (SQL MCP Server) in Azure AI Foundry (Prompt Agent vs. Hosted Agent)
Azure AI Foundry: Entra User Identity Passthrough to Remote MCP (Prompt Agent vs. Hosted Agent) Hello Microsoft Community, I'm trying to determine whether Azure AI Foundry supports end-user identity passthrough when invoking a Remote MCP Server (SQL…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Access issue due to sa account
Hi, To issue Microsoft OLE DB Provider for SQL Server Cannot open database "hMailserver" requested by the login. I can logon on SSMS using the same sa account. I am using Sql server 14.0.1000. Any reason?
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SSIS job scheduled failed to connect to Azure Data Warehouse
Previously, we are able to run SSIS jobs to retrieve data from Azure Data Warehouse. We are migrating to a New Server. It is fine to connect through SSMS or run the SSIS package in Visual Studio on this new server. However, running the SSIS jobs failed…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Migrating varbinary data from onprem SQL table to Azure blob storage.
Hi, I need to move the varbinary data in one of my on Prem SQL data table column Column(binary_data) which needs to be uploaded to azure blob storage. We have 2 million rows in the table and every row should create one file in the blob storage for…
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Import an Excel spreadsheet into SQL
How do I import an Excel spreadsheet into SQL STudio
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SSIS installed on Azure Marketplace SQL Server 2025 VM, but SSIS Catalog components are missing
I deployed a VM from the Azure Marketplace image: Publisher: microsoftsqlserver Offer: sql2025-ws2025 Plan: standard-gen2 Environment: SQL Server Version Microsoft SQL Server 2025 (RTM-CU7) (KB5096981) 17.0.4065.4 (X64) Standard Edition SSMS…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Cannot Deploy SSIS project. Error: Could not load type Microsoft.Internal.VisualStudio.Shell.Interop.IVsCustomTelemetryService from assembly Microsoft.Internal.VisualStudio.Interop PublicKey
I get this error trying to deploy a package after installing VS2026 March 2026 release Version 18.4.2. All though it does deploy the error pops up after every step during deployment. I tried a repair, I tried removing the ComponentModelCache folder and…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Visual Studio 2022 Enterprise - SSDT - Nessus Vulnerabilities
Hello support team, We want to install SSDT vsix for Visual Studio Enterprise 2022. Our vulnerability assessment solution Nessus is highlighting SSDT component as critical vulnerabilities concerning following files which are packaged with SSDT. Is there…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.