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
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
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
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
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
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 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 | Other
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
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
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
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
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
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
Windows for business | Windows Server | User experience | Other
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 | Other
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
Developer technologies | Visual Studio | Extensions
Developer technologies | Visual Studio | Other
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
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
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
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
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…