2,786 questions

Sort by: Updated
1 answer

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 Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,660 questions
asked 2022-04-10T00:09:47.347+00:00
Santiago S 1 Reputation point
edited an answer 2026-11-13T04:57:59.71+00:00
Santiago S 1 Reputation point
1 answer

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2021-04-08T14:33:05.567+00:00
Deepak 121 Reputation points
edited an answer 2026-11-13T04:27:38.71+00:00
Deepak 121 Reputation points
3 answers

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
Azure Key Vault

An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.

1,524 questions
Azure Database Migration Service
Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

12,111 questions
SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2020-12-29T17:41:43.283+00:00
HemantSudehely-0557 246 Reputation points
edited an answer 2026-11-13T04:20:30.61+00:00
HemantSudehely-0557 246 Reputation points
0 answers

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2025-10-29T08:47:48.8533333+00:00
Uma 491 Reputation points
1 answer

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-10-30T18:54:31.6566667+00:00
Akshay Kanade 0 Reputation points
answered 2026-10-30T18:56:09.01+00:00

AI answer

2 answers

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-10-23T09:58:15.8066667+00:00
answered 2026-10-26T16:15:41.93+00:00
Yitzhak Khabinsky 27,196 Reputation points
2 answers

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2020-08-25T04:38:04.257+00:00
Mav 86 Reputation points
edited a comment 2026-10-25T09:04:54.71+00:00
P sridattu reddy 0 Reputation points
1 answer

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-10-07T13:53:15.2833333+00:00
Kathiravan P 0 Reputation points
answered 2026-10-07T13:53:29.7633333+00:00

AI answer

1 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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-10-07T06:47:56.7133333+00:00
harika manepalli 0 Reputation points
edited a comment 2026-10-07T11:54:33.2+00:00
Senthil kumar 3,000 Reputation points
2 answers

SQLLOCAL.exe cannot be found #sql

Resolving "SqlLocalDB.exe Not Found I can't find it. #SQL

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-10-02T21:16:57.1566667+00:00
Jay Voodoo 0 Reputation points
answered 2026-10-02T21:51:04.27+00:00
Erland Sommarskog 138.7K Reputation points MVP Volunteer Moderator
3 answers One of the answers was accepted by the question author.

SQL SERVER SUPPORT

How can I get sql server support from microsoft?

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,660 questions
asked 2023-09-26T00:03:22.7533333+00:00
R.B.V 100 Reputation points
answered 2026-09-30T15:02:12.94+00:00
Tejesh Gour 0 Reputation points
1 answer

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-09-08T07:50:13.63+00:00
Herman Tsago 0 Reputation points
answered 2026-09-19T15:13:57.78+00:00
Walker Pollitt 400 Reputation points
3 answers One of the answers was accepted by the question author.

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-08-21T09:24:27.23+00:00
Jonathan 480 Reputation points
commented 2026-09-01T06:39:05.8366667+00:00
Jonathan 480 Reputation points
7 answers One of the answers was accepted by the question author.

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,660 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 60 Reputation points
commented 2026-08-26T04:29:46.2533333+00:00
Nkrumah Richards 0 Reputation points
1 answer

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-08-18T06:54:12.76+00:00
Aurnorakarnkij, Sanit 0 Reputation points
answered 2026-08-18T18:34:59.5833333+00:00
Yitzhak Khabinsky 27,196 Reputation points
2 answers

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
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

12,111 questions
SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,660 questions
asked 2024-10-21T14:22:23.4666667+00:00
Anonymous
commented 2026-08-12T14:26:21.2366667+00:00
manish verma 516 Reputation points
3 answers

Import an Excel spreadsheet into SQL

How do I import an Excel spreadsheet into SQL STudio

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-08-11T07:54:32.2+00:00
Ian Jones 0 Reputation points
commented 2026-08-11T13:45:09.81+00:00
Yitzhak Khabinsky 27,196 Reputation points
1 answer

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-08-05T09:05:51.61+00:00
Kris Reynolds 0 Reputation points
edited the question 2026-08-05T09:37:04.7+00:00
Erland Sommarskog 138.7K Reputation points MVP Volunteer Moderator
2 answers

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-03-27T13:39:52.1333333+00:00
Barr, David 15 Reputation points
commented 2026-07-21T17:09:14.3966667+00:00
BSH 0 Reputation points
0 answers

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
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
asked 2026-07-15T13:33:57.0233333+00:00
GallW 0 Reputation points
edited the question 2026-07-15T14:11:56.8366667+00:00
GallW 0 Reputation points