2,742 questions with SQL Server Integration Services tags

Sort by: Updated
1 answer

SQL Server Import and Export Wizard: Can not go back after error

Hi. After finishing an import using the SQL Import and Export Wizard, and if there's an error, I can't find a way to go back and fix it, even though the wizard indicates at the top that this should be possible: It's very annoying to have to start from…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-22T10:46:52+00:00
Norbert Harrer 0 Reputation points
commented 2025-10-25T09:07:04.59+00:00
Norbert Harrer 0 Reputation points
2 answers

Does sqlcmd have block insertion?

First of all, Hello everyone! The problem is i started using sql server on other operative system than windows. I have followed almost all of the article in the documentation. Installed docker Installed sql cmd Installed the image Ran the commands…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-22T14:48:38.8733333+00:00
JORYSNIEL MATA NUÑEZ 0 Reputation points
answered 2025-10-23T09:11:17.0633333+00:00
Akhil Gajavelly 645 Reputation points Microsoft External Staff Moderator
2 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,742 questions
asked 2025-10-21T09:35:20.2233333+00:00
Stéphane Bergeron 0 Reputation points
edited a comment 2025-10-23T08:17:20.55+00:00
Rekha 0 Reputation points Microsoft External Staff Moderator
0 answers

Unexpected API Response Error 16464 — Need Clarification

System.InvalidOperationException: Operation failed with error code <error_code_188827> at MyApp.Controllers.PaymentController.ProcessRequest(18882749655) in /src/Controllers/PaymentController.cs:line 496 at MyApp.Program.Main(String[] args)…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-09-11T16:52:58.3766667+00:00
karish harry 25 Reputation points
commented 2025-10-23T07:47:37.4066667+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 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,742 questions
asked 2025-09-29T21:41:51.41+00:00
Jeff Franken 0 Reputation points
commented 2025-10-22T05:29:42.18+00:00
Akhil Gajavelly 645 Reputation points Microsoft External Staff Moderator
1 answer

How to download SQL server 2022 license

Our legal team needs to update the SQL Server 2022 license, which is currently missing from the official product. Please refer to the attached screenshot for reference. Could you please guide me on how to download the SQL Server 2022 license? Kindly…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-06T05:57:30.2566667+00:00
Jyothishkumar K R 0 Reputation points
recommended 2025-10-21T21:11:23.36+00:00
Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
6 answers

SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
SQL Server | Other
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 66 Reputation points
commented 2025-10-21T15:55:11.85+00:00
Attila Papp 0 Reputation points
3 answers One of the answers was accepted by the question author.

Visual Studio 2015 / SSIS / Excel Connection Manager Issue (The requested OLE DB provider Microsoft.ACE.OLEDB.15.0 is not registered).

Hi all I have a scenario where I'm having to revisit an old SSIS Package that was developed some 4/5 years ago and I'm having a particular challenge dealing with an error / issue when trying to run the package from Visual Studio (2015). Essentially, I'm…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-19T13:47:51.7+00:00
Michael Parker 20 Reputation points
accepted 2025-10-21T13:14:27.5033333+00:00
Michael Parker 20 Reputation points
1 answer

Big file with lots of columns doesn't output content of many of them

Good day. I have a SSIS package that selects the data using the following statement: EXECUTE im_automation.accent_changes WITH RESULT SETS ( ( [Source] VARCHAR(30), Category VARCHAR(30), ProvType VARCHAR(30), [Social…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-07T16:58:13.9866667+00:00
Naomi Nosonovsky 8,771 Reputation points
commented 2025-10-21T12:56:25.2566667+00:00
Naomi Nosonovsky 8,771 Reputation points
1 answer

ADO.NET ignores parameter names when IsQueryStoreProcedure is set to True

ADO.NET ignores parameter names when IsQueryStoreProcedure is set to True. I use the "Execute SQL Task" to call a stored procedure with optional parameters via ADO.NET . The following situation occurs with all providers except…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-09-22T13:08:39.9766667+00:00
Gregory Lvov 0 Reputation points
commented 2025-10-21T04:37:48.35+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to fix error in running of .DTSX file

Message Executed as user: HRPROWSIDB\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.6560.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 6:12:38 PM Error: 2025-10-07 18:12:38.27 …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-07T10:27:18.56+00:00
Jerome C. Espenilla 20 Reputation points
commented 2025-10-13T00:04:27.17+00:00
Jerome C. Espenilla 20 Reputation points
2 answers One of the answers was accepted by the question author.

SSIS script task throws out of memory exception on 3mln rows file

I have a SSIS package with the following script task to add footer to the file: #region Help: Introduction to the script task /* The Script Task allows you to perform virtually any operation that can be accomplished in * a .Net application within the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-07T17:20:03.17+00:00
Naomi Nosonovsky 8,771 Reputation points
accepted 2025-10-12T00:55:19.2466667+00:00
Naomi Nosonovsky 8,771 Reputation points
3 answers One of the answers was accepted by the question author.

SSIS 2022 CDC Control Task

We get the following error when running SSIS packages that contain attunity CDC Control Tasks in our SQLServer 2022 environment on Windows2019 : CDC Control Task:Error: The Validate method on the task failed, and returned error code 0x80131040 (Could not…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
Windows for business | Windows Server | User experience | Other
asked 2023-02-14T15:09:14.8666667+00:00
Tom J 40 Reputation points
answered 2025-09-29T19:14:24.0633333+00:00
Tiago Elias 0 Reputation points
9 answers

SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services

Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
SQL Server | Other
asked 2023-02-20T09:37:55.24+00:00
Alessandro Di Pasquale 15 Reputation points
edited a comment 2025-09-22T14:26:19.57+00:00
Jesús Miguel Lopez mesia 0 Reputation points
2 answers

Error loading Oracle components in VS 2019 after SSIS upgrade to version 4.6 and rollback to 3.16

I'm getting the following error when attempting to open an Oracle source, destination, or connection manager in VS 2019. The text version of the above screenshot and message details are in the code block below. We began encountering this error after…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
Developer technologies | Visual Studio | Extensions
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.
5,524 questions
asked 2024-06-20T18:12:19.3033333+00:00
Amanda Hansen 5 Reputation points
commented 2025-10-07T21:11:56.3933333+00:00
Cynthia 0 Reputation points
3 answers One of the answers was accepted by the question author.

Derived Column Error

I have created a package where I am using a derived column for date. I have defined the column in my table as below: [LAST_FOUND] [date] NULL The format of the values in excel file are: My derived column expression is (DT_DBDATE)[Last Found] And I…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-09-09T23:09:42.0333333+00:00
Ali Ahad 151 Reputation points
commented 2025-09-15T22:19:40.2766667+00:00
Ali Ahad 151 Reputation points
1 answer

Login timeout expired error while connecting with mysql server from Oracle using ODBC

isql -v MSSQLDEV usg_hrm ******** [S1T00][unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired [08001][unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x102 [08001][unixODBC][Microsoft][ODBC Driver 17 for…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-09-15T11:05:58.73+00:00
NAEEM AKRAM 0 Reputation points
answered 2025-09-15T21:25:41.01+00:00
Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Will Excel VBA Azure SQL ADODB.connection using SQLOLEDB continue to work post Oct 1, 2025

I use Excel VBA to connect to Azure SQL using userid and password via ADODB connection "Provider=SQLOLEDB;Password=MyPwd;User ID=MyUser; Data Source=Mysqldbserver.database.windows.net,1433; "Use Encryption for Data=True; Initial…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-09-24T17:10:44.5833333+00:00
Gordon Alexander 20 Reputation points
accepted 2025-09-25T11:24:00.3+00:00
Gordon Alexander 20 Reputation points
1 answer One of the answers was accepted by the question author.

SSIS: Handling Identity Mapping When Migrating Data Between Databases

Hi, I’m new to SSIS and have been assigned to migrate data from an old database (v1) to a newer one (v2). The newer database already contains data, and its tables use identity columns as primary keys. The challenge is that there are multiple tables…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-07T06:10:11.36+00:00
Benjamin Heredia 20 Reputation points
accepted 2025-10-08T05:09:34.37+00:00
Benjamin Heredia 20 Reputation points
2 answers One of the answers was accepted by the question author.

Migrating SSIS from using Microsoft Connector for Oracle to ADO.NET

From another post : With Microsoft's notice back in January that SSIS in SQL Server 2025 no longer being supported, we're looking to move from the Microsoft Connector for Oracle (prev known as Attunity) over to the ADO.NET source and destinations that…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 questions
asked 2025-10-08T18:39:59.54+00:00
OMAR SALEK 20 Reputation points
accepted 2025-10-10T09:26:54.78+00:00
OMAR SALEK 20 Reputation points