SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
2 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
asked 2025-06-24T18:20:55.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ryan
6
Reputation points
edited a comment 2025-06-26T12:16:17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
26,586
Reputation points
0 answers
how to fix issue om.microsoft.sqlserver.jdbc.TDSChannel enableSSL WARNING: TDSChannel ( ConnectionID:1 TransactionID:0x0000000000000000) SSL handshake failed: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
Previously, I used JDK 1.6.0, but due to company requirements, I had to switch to OpenJDK 8u422 in Eclipse. After making the change, I received warnings, and some functions also showed warnings when running. There are a few functions that do not display…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-24T01:07:50.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 42%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Toan Nguyenngoc
0
Reputation points
asked 2025-06-24T01:07:50.8+00:00
Toan Nguyenngoc
0
Reputation points
8 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,702 questions
SQL Server Other
14,494 questions
asked 2023-02-20T09:37:55.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 97%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Alessandro Di Pasquale
15
Reputation points
commented 2025-06-18T21:01:15.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 9%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Marcelo Vega Janhsen
0
Reputation points
0 answers
Cannot create a task from XML for task "Script Task" | XML task | SSIS | Version
Microsoft (R) SQL Server Execute Package Utility Version 16.0.1000.6 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 11:33:22 AM Error: 2025-06-17 11:33:23.68 Code: 0xC001F02A Source: 0_Test Description: Cannot create a…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-17T21:46:52.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sravan Kopparapu
0
Reputation points
commented 2025-06-18T05:40:05.9833333+00:00
Olaf Helper
47,436
Reputation points
1 answer
One of the answers was accepted by the question author.
How I can change a file name with code in SSIS
I'm trying to change a file name to current year and Previous month with below script but it is still coming as current year and current month. I tried around to fix it but no luck. If anyone can show my mistake please "D:\Sales" +…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-16T20:32:08.67+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 53%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Van Alstyne
20
Reputation points
accepted 2025-06-17T19:29:43.9833333+00:00
Van Alstyne
20
Reputation points
0 answers
VS2022 SSIS cannot load ODBC data column
Hi I'm trying to use VS 2022 Community SSIS to connect some ODBC data sources like SAP Hana or SQL Server 2022. I can see the table and data in Preview page, but cannot see any data columns in the "data column setting", any ideas about…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-17T02:46:40.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Angi Wang
0
Reputation points
commented 2025-06-17T12:15:39.94+00:00
Yitzhak Khabinsky
26,586
Reputation points
0 answers
SSIS package row delimiter Issue
Hi, I have a package that reads a file from a network location and inserts the data into a database. The data flow task includes four components: Flat File Source Derived Column to convert DT_NText to DT_WTSR Derived Column to convert DT_WTSR to…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-06T16:08:49.3166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 74%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Karthik Ponugoti
0
Reputation points
edited a comment 2025-06-09T15:10:21.0966667+00:00
Yitzhak Khabinsky
26,586
Reputation points
0 answers
SSIS package row delimiter Failure
Hi, I have a package that reads a file from a network location and inserts the data into a database. The data flow task includes four components: Flat File Source Derived Column to convert DT_NText to DT_WTSR Derived Column to convert DT_WTSR to…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-06T16:02:21.78+00:00
Karthik Ponugoti
0
Reputation points
asked 2025-06-06T16:02:21.78+00:00
Karthik Ponugoti
0
Reputation points
0 answers
Deployed SSIS package has access denied to file directories and work fine in VS
I’ve tested a couple of things out with different packages that have been deployed to SQL Server. I noticed that within the same package, I can have a script task which fails to connect to a file directory but I don’t have an issue with connecting a flat…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-02T15:38:53.3733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 55.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Apostolu, Chris
0
Reputation points
asked 2025-06-02T15:38:53.3733333+00:00
Apostolu, Chris
0
Reputation points
0 answers
Any easy way to determine what SSIS Package references a file name? And what Job then references that SSIS Package?
We have been provided a list of file names that were processed in error...all with pretty much the same file name prefix of NCMT_CareQualityManagement with its final part being a DateTime stamp. Is there any easy way to determine what SSIS Packages…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-29T18:30:46.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
231
Reputation points
commented 2025-05-29T20:07:36.7166667+00:00
Yitzhak Khabinsky
26,586
Reputation points
1 answer
SSIS and delimiting a VARCHAR Data Column with a single quotation mark
We need to set-up a data pump in SSIS for our Provider Directory Table to a .csv file. The SSIS Package failed because we have a last name of O'brien and the parsing of the file is failing because of that single apostrophe. Is this simply a matter of…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-28T12:34:27.86+00:00
Bobby P
231
Reputation points
answered 2025-05-28T12:59:16.5033333+00:00
Yitzhak Khabinsky
26,586
Reputation points
1 answer
One of the answers was accepted by the question author.
SSIS connection issues
Hi everybody, We upgraded our SQL Server to SQL Server 2022. The SSIS server is 2019. We're getting the following error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-19T23:30:57.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
8,431
Reputation points
commented 2025-05-28T12:56:56.5566667+00:00
Yitzhak Khabinsky
26,586
Reputation points
2 answers
SQL Server Integration Services Projects Installation process doesn't allow to install or uninstall
Hi, I'm trying to install and use SQL Server Integration Services, but getting this message either when I try to install or uninstall the product. I'm not able to click on the checkbox, so the Install button is disable. I have tried with several versions…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2024-08-06T17:49:18.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 79%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Obregon_Rigoberto
0
Reputation points
commented 2025-05-26T23:53:30.8133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 34%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Agger, Marc
0
Reputation points
2 answers
Boolean Value Change in OLEDB Source of SSIS Data Flow in SSIS
SSIS doesn't throw error for any implicit conversion in dataflow at compile time unless we execute it. We have this column called DBAName in source which is Boolean, and target datatype is DT_STR (as you can see in the following two screenshots). …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-21T04:07:51.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 21%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Arindam Roy (IN)
0
Reputation points
commented 2025-05-26T12:40:47.2866667+00:00
Olaf Helper
47,436
Reputation points
1 answer
Best Practice for SSIS Connection Managers
What is, shall we say, best practice for configuring Configuration Managers when developing for using "Development"/"Production" file path names? Dev/Prod SQL Server Names? Etc. I have seen using SSIS Project Parameters to do so. But…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-23T17:51:51.5633333+00:00
Bobby P
231
Reputation points
answered 2025-05-23T18:36:31.8933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
60,161
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,702 questions
Developer technologies Visual Studio Extensions
297 questions
Developer technologies Visual Studio Other
5,451 questions
asked 2024-06-20T18:12:19.3033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 73%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Amanda Hansen
0
Reputation points
commented 2025-05-20T13:30:48.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 7.000000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEW%3C/text%3E%3C/svg%3E)
Erik Wigbout
0
Reputation points
1 answer
SSIS Data Conversion Redirecting Rows to Error Output Despite Valid Data
I have a Data Conversion component in SSIS that keeps redirecting rows to the error output despite the data being valid. The FIRE_SIZE_CLASS column only contains single characters A-G, confirmed through inspection, and the conversion is set to DT_STR…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-15T15:52:02.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Cuamsia
0
Reputation points
answered 2025-05-16T05:53:08.09+00:00
Olaf Helper
47,436
Reputation points
1 answer
One of the answers was accepted by the question author.
Running SSIS both using command or using SQL Server Agent keeps failing
Hello everyone, I am running an export of our SQL Database using SQL Server Management Studio and it fails when I try to automate it Manually running the export by Right Click>Tasks>Export Data will work fine and I will be able to get the output…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 96%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
SSIS job fails when run as a scheduled job - access denied
I created a job to export 4 SQL 2019 tables to an Excel workbook using the Export Data task to create the SSIS package in SSMS. The process works fine in SSMS but when I run the created SSIS package in SQL Agent, it fails due to access denied. It seems…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-08T19:01:33.9333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 89%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Michael Harris
20
Reputation points
commented 2025-05-09T17:24:54.9966667+00:00
Michael Harris
20
Reputation points
1 answer
When tried to export my database that is in SQL database to bacpac got the errorFailed to export the database: nexxus-oltp-prod. ErrorCode: undefined ErrorMessage: The Export operation failed because database is larger than max supported size.
When tried to export my database that is in SQL database to bacpac got the errorFailed to export the database: nexxus-oltp-prod. ErrorCode: undefined ErrorMessage: The Export operation failed because database is larger than max supported size.
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-08T02:40:39.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Sripathi Eravelly
0
Reputation points
answered 2025-05-08T19:35:22.57+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
77,686
Reputation points
Volunteer Moderator