2,758 questions with SQL Server Integration Services tags

Sort by: Updated
2 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-07-18T21:21:56.5733333+00:00
Martin Williams 0 Reputation points
commented 2025-12-02T10:30:58.3066667+00:00
Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server 2022 import wizard missing MS Excel option

SQL Server 2022 import wizard missing MS Excel option

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-11-21T13:01:40.7333333+00:00
Shahidullah All Mahmod 0 Reputation points
commented 2025-12-01T12:57:47.2166667+00:00
Lakshmi Narayana Garikapati 640 Reputation points Microsoft External Staff Moderator
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,758 questions
asked 2025-06-24T18:20:55.04+00:00
Ryan 16 Reputation points
edited a comment 2025-11-28T19:33:59+00:00
Ryan 16 Reputation points
1 answer

Inquiry Regarding Migration from SQL Server 2019 to SQL Server 2022 and SSIS 2012 Migration Path

Dear Microsoft Support Team, I hope you are doing well. Our team is currently running SQL Server 2019 and using SSIS packages developed in SQL Server Integration Services (SSIS) 2012. We are planning to migrate our environment to SQL Server 2022, and we…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-11-28T09:12:30.29+00:00
TIPPAWAN SOMSEE 0 Reputation points
edited the question 2025-11-28T13:56:44.2+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
4 answers One of the answers was accepted by the question author.

SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server

Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
1,127 questions
SQL Server | Other
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2021-05-03T11:51:51.583+00:00
Lynn Carelse 21 Reputation points
commented 2025-11-28T06:43:17.03+00:00
Muhammad Erik Rahman Mulyana 0 Reputation points
0 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-08-13T16:53:33.8466667+00:00
shreyansh raj 0 Reputation points
commented 2025-11-27T09:19:43.4333333+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
1 answer

Getting error in SSIS package, using attunity connector

Hello, I'm trying to get help on a issue I'm trying to deal with. Got a new wokstations here, with fresh installed VS, SSIS, MS Oracle connector, etc. I get to work on SSIS Packages, that intend to extract data from Oracle DBs, using an old attunity…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-07-17T13:26:19.4+00:00
Mathieu Mussler 0 Reputation points
commented 2025-11-27T06:42:59.0166667+00:00
Venkata Ramanamma Uppu (Quadrant Technologies LLC) 0 Reputation points Microsoft External Staff
0 answers

SSIS error

Good morning everyone, I'm getting the following error [Execute SQL Task] Error: Executing the query "DECLARE @ReturnCode INTEGER = 0; [Execute SQL Task] Error: Executing the query "DECLARE @RerurnCode INTEGER = 0; excute ? OUTPU..."…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-11-25T18:27:45.5966667+00:00
Naomi Nosonovsky 8,881 Reputation points
commented 2025-11-26T05:43:51.6533333+00:00
Akhil Gajavelly 875 Reputation points Microsoft External Staff Moderator
2 answers

Error: 40 - Could not open a connection to SQL Server

We are encountering an issue while importing data from a data warehouse hosted on SQL Server into Power BI. The connection is established successfully, and the import begins as expected. However, after running for some time, the process fails with the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-11-25T21:24:25.6+00:00
Moorthy, Jayachandran 0 Reputation points
answered 2025-11-25T21:40:22.93+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
0 answers

Connection string

Hello, I have a connection string which works on the old production server but doesn't work on the new production server. <?xml version="1.0"?> <DTSConfiguration> <DTSConfigurationHeading> <DTSConfigurationFileInfo …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-10-28T16:55:24.61+00:00
Naomi Nosonovsky 8,881 Reputation points
edited a comment 2025-11-25T12:43:20.3133333+00:00
Naomi Nosonovsky 8,881 Reputation points
1 answer

Upgraded VS to version 16.11.49 but now my original SSIS package is not appearing

Hi I updated VS to version 16.11.49 but now my original SSIS package is not available. I can create new SSIS package but I cannot access my original one. Below are some screenshots: Message I get when I open my original SSIS package: SSIS is…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-07-17T04:03:25.14+00:00
Manny 151 Reputation points
answered 2025-11-25T05:03:05.6333333+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
1 answer

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,758 questions
asked 2025-11-20T15:13:24.2266667+00:00
Francisco Ruiz 0 Reputation points
commented 2025-11-24T10:05:57.76+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

how can I strip unprintable ascii characters from a flat file transformation in ssis

I am loading a flat file to another flat file with headers. the source file has rows with unprintable ascii characters. I need to strip those out. it is giving truncation errors as the characters are making it think the field is too long. what is the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-09-29T21:41:51.41+00:00
Jeff Franken 0 Reputation points
commented 2025-11-20T07:09:49.5333333+00:00
Akhil Gajavelly 875 Reputation points Microsoft External Staff Moderator
2 answers

When I try to install sql server express 2019 it shows the system can not find specified path

I have tried to install SQL server express 2019 for many times, but It shows the system can not find specified path. I donwload from official site And uninstall all the previous sql server, but still shows this problem

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-11-12T18:31:12.8633333+00:00
Abu Saleah 0 Reputation points
commented 2025-11-19T05:41:26.54+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
1 answer

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-07-31T11:15:48.86+00:00
Wolfgang 0 Reputation points
commented 2025-11-18T12:54:30.0933333+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
1 answer

SSIS Annotation and changing font color

We have an Annotation explaining some detail in a SSIS Package. My color theme is "Dark" and I do see some rumblings about an issue with "Dark" theme when trying to change the font color of the Annotation to yellow. It will take in…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-11-04T16:37:49+00:00
Bobby P 231 Reputation points
commented 2025-11-17T12:32:19.5966667+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
1 answer

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 Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-08-07T21:59:33.9766667+00:00
Oktay Bozdemir 41 Reputation points
commented 2025-11-13T10:38:14.65+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server 2022, Visual Studio 2022 - Microsoft VB 2022 script task interacting with Excel COM Errors

We have some SSIS packages that interact with Excel files. The SSIS packages output the data to the excel spreadsheets that include a template row so that numbers are formatted as numbers.. etc. There are also pivot tables that exist on other tabs of…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-10-31T20:27:55.9566667+00:00
Guilfoy, Kristy 20 Reputation points
answered 2025-11-12T15:08:25.9733333+00:00
Guilfoy, Kristy 20 Reputation points
0 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 questions
asked 2025-08-28T14:42:13.1433333+00:00
shreyansh raj 0 Reputation points
commented 2025-11-12T12:16:42.7133333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 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,758 questions
asked 2025-08-13T20:37:02.52+00:00
Greg Troyan 0 Reputation points
answered 2025-11-12T04:44:41.3266667+00:00
Shruti Dhruv 0 Reputation points