2,700 questions with SQL Server Integration Services tags

Sort by: Updated
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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
asked 2023-02-20T09:37:55.24+00:00
Alessandro Di Pasquale 15 Reputation points
commented 2025-06-18T21:01:15.63+00:00
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,700 questions
asked 2025-06-17T21:46:52.69+00:00
Sravan Kopparapu 0 Reputation points
commented 2025-06-18T05:40:05.9833333+00:00
Olaf Helper 47,416 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,700 questions
asked 2025-06-16T20:32:08.67+00:00
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,700 questions
asked 2025-06-17T02:46:40.8633333+00:00
Angi Wang 0 Reputation points
commented 2025-06-17T12:15:39.94+00:00
Yitzhak Khabinsky 26,576 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,700 questions
asked 2025-06-06T16:08:49.3166667+00:00
Karthik Ponugoti 0 Reputation points
edited a comment 2025-06-09T15:10:21.0966667+00:00
Yitzhak Khabinsky 26,576 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,700 questions
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,700 questions
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,700 questions
asked 2025-05-29T18:30:46.6766667+00:00
Bobby P 231 Reputation points
commented 2025-05-29T20:07:36.7166667+00:00
Yitzhak Khabinsky 26,576 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,700 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,576 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,700 questions
asked 2025-05-19T23:30:57.98+00:00
Naomi Nosonovsky 8,431 Reputation points
commented 2025-05-28T12:56:56.5566667+00:00
Yitzhak Khabinsky 26,576 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,700 questions
asked 2024-08-06T17:49:18.45+00:00
Obregon_Rigoberto 0 Reputation points
commented 2025-05-26T23:53:30.8133333+00:00
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,700 questions
asked 2025-05-21T04:07:51.68+00:00
Arindam Roy (IN) 0 Reputation points
commented 2025-05-26T12:40:47.2866667+00:00
Olaf Helper 47,416 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,700 questions
asked 2025-05-23T17:51:51.5633333+00:00
Bobby P 231 Reputation points
answered 2025-05-23T18:36:31.8933333+00:00
Michael Taylor 59,991 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…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,449 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
295 questions
asked 2024-06-20T18:12:19.3033333+00:00
Amanda Hansen 0 Reputation points
commented 2025-05-20T13:30:48.8266667+00:00
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,700 questions
asked 2025-05-15T15:52:02.09+00:00
Cuamsia 0 Reputation points
answered 2025-05-16T05:53:08.09+00:00
Olaf Helper 47,416 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,700 questions
asked 2025-05-13T09:48:23.75+00:00
Gio 20 Reputation points
commented 2025-05-16T01:37:15.8+00:00
Gio 20 Reputation points
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,700 questions
asked 2025-05-08T19:01:33.9333333+00:00
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,700 questions
asked 2025-05-08T02:40:39.0266667+00:00
Sripathi Eravelly 0 Reputation points
answered 2025-05-08T19:35:22.57+00:00
Bruce (SqlWork.com) 77,631 Reputation points Volunteer Moderator
1 answer

Unable to upgrade SSISDB -Doesn't match the version of upgrade tool

Hi All, I am trying upgrade SSISDB in SQL 2022 , The SSISDB backup I have copied from SQL 2014. While running ISDBUpgradeWizard I am getting below error. "TITLE: SQL Server Integration Services The version of the sql server instance (16.0.4175.1)…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
asked 2025-05-07T16:11:08.3133333+00:00
Ambily Jose 25 Reputation points
answered 2025-05-08T06:01:41.71+00:00
Olaf Helper 47,416 Reputation points
2 answers One of the answers was accepted by the question author.

Can't find Targetserverversion as Sql server 2016 in VS 2022

Hi, I have SQL 2016 and VS2022, recently upgraded visual studio to VS2022 and trying to edit the package compatible with version 2016. But, I can't find the targetserverversion as SQL 2016, only I can see SQL 2017, 2019, 2022. Please suggest the…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,449 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
Visual Studio Testing
Visual Studio Testing
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Testing: The act or process of applying tests as a means of analysis or diagnosis.
370 questions
asked 2023-04-07T11:24:07.33+00:00
Sarojkumar 20 Reputation points
answered 2025-05-07T17:25:03.2466667+00:00
Paul D 0 Reputation points