2,789 questions with SQL Server Integration Services tags

Sort by: Updated
1 answer

SSIS 2019/2022 - Teradata 20.00 - Microsoft Teradata Connector - Source and Destination not showing in SSIS Toolbox after installation

I have to upgrade to Teradata 20.00 and cannot get the Teradata Source and Destination Tools to show up in SSIS 2022 with VS2022. I have tried with the packages targeting 2019 and 2022. The installation of the connector itself claims to have been…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-04-29T15:20:20.2533333+00:00
Susann 0 Reputation points
answered 2026-04-29T15:21:00.58+00:00
Q&A Assist
1 answer

Issues with SSIS packages after upgrading SQLServer from 2019 to 2022.

These packages have been running successfully for years, but failed after upgrading SQLserver to 2022. Further detail: the package contains a Script task (VB) that creates and populates files on the file system (either excel or PDF). We have two…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-04-28T18:10:56.7+00:00
Ben Pflanzer 0 Reputation points
commented 2026-04-29T12:13:29.7+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
1 answer

SSIS Package Fails with System.Data.SQLite Could Not Load Error (E_POINTER)

I have deployed an SSIS project using an .ispac file into SSISDB. The project contains Cdata Odoo components and Kingswaysoft toolkit. When I try to execute the package (both from SSISDB and from Visual Studio), it fails with the following…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-04-29T06:12:42.41+00:00
Ishika Raiyani 20 Reputation points
commented 2026-04-29T10:04:13.5333333+00:00
Ishika Raiyani 20 Reputation points
3 answers

unable to install SQL server setup exist code (decimal): 2068052413 error description. Fatal error during installation

Hi guys, i encountered the above error message and will need your help. I opened the error description link and it opens up xbox page.. Got confused! As i have read the error description but i don't understand it The error log summary text folder is…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-04-06T13:41:58.38+00:00
Olumide Kuforiji 0 Reputation points
recommended 2026-04-28T16:23:25.4033333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

The SQL server 2019 installation failed in Windows Server 2025.

The SQL server 2019 installation failed in Windows Server 2025. From the logs, we understood that, installation fails because Microsoft Visual Studio Tools for Applications (VSTA) 2017 - a dependency of the Integration Services (SSIS) feature - crashes…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-04-22T07:15:56.7+00:00
Siji, Merlin 0 Reputation points
commented 2026-04-28T06:05:59.6833333+00:00
Siji, Merlin 0 Reputation points
1 answer

Oracle source and destination missing in visual studio 2022 after installing Microsoft Connector for Oracle v1.2/1.3

We are running SSIS packages originally developed for SQL Server 2016 on servers that have been upgraded to SQL Server 2022 (both OS and database engine). The packages use the Attunity Oracle connectors. After the upgrade we attempted to open the…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-04-20T20:13:59.91+00:00
vamsi krishna 0 Reputation points
commented 2026-04-28T05:53:03.4633333+00:00
Akhil Gajavelly 1,820 Reputation points Microsoft External Staff Moderator
3 answers

SQL Server 2025 - DTExec.exe.config file included assembly dependancies range for Microsoft.Data.SqlClient.dll

We observed that DTExec.exe.config (SQL Server 2025 SSIS runtime) contains an assemblyBinding bindingRedirect entry for Microsoft.Data.SqlClient with oldVersion="0.0.0.0-5.0.0.0" redirecting to newVersion="5.0.0.0". We integrate…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-04-20T14:28:11.3366667+00:00
Abhishek Modi (amodi) 20 Reputation points
commented 2026-04-28T05:19:59.11+00:00
Akhil Gajavelly 1,820 Reputation points Microsoft External Staff Moderator
2 answers

SQL server gave me data baste engine recovery failed AT EXIT CODE -2061893606 ERROR

after downloading and after doing the 4k setup provided here i tried installing but got an error -2061893606 and the Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time:…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-01-14T21:46:11.5966667+00:00
mohmaed ahmed mohamed rahmo 0 Reputation points
recommended 2026-04-21T09:19:05.0533333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 answers

Build errors when adding SQL Server 2025 (v17) support

Hi Team, I am updating a project to add support for SQL Server 2025 (V17.x), but I am encountering the following build errors: error CS0234: The type or namespace name 'Smo' does not exist in the namespace 'Microsoft.SqlServer.Management' (are you…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-01-12T07:43:28.86+00:00
Abhishek Modi (amodi) 20 Reputation points
recommended 2026-04-21T09:18:01.05+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 answers

The SQL Server Management studio no longer shows running SSIS packages

Hi everyone, I run a bunch of SSIS packages in a SQL Server Agent job. The packages are deployed as files in the file system. They are executed as SQL Server Agent Service Account. I used to be able to see them under Running Packages. Today, they weren't…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2025-12-19T21:51:23.88+00:00
Igor Gelin 0 Reputation points
recommended 2026-04-21T09:16:53.5466667+00:00
Madhavi Taniparthi 0 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,789 questions
asked 2025-11-25T21:24:25.6+00:00
Moorthy, Jayachandran 0 Reputation points
recommended 2026-04-21T07:28:14.3233333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

SSIS - How to create an ELT process that is schema-adapative

How can I create an ELT process that is schema-adapative? If new columns are added in the source, those columns should be added to the destination and populated. If columns are otherwise changed, alters should be executed on the destination. We could…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
SQL Server | Other
asked 2023-05-23T21:08:05.9566667+00:00
Tampa Ken 20 Reputation points
commented 2026-04-18T15:01:02.28+00:00
Ivan Mitev 0 Reputation points
1 answer

In my Data Flow OLE DB Source, can I write a SQL Query that is dependent on a SSIS Variable

For instance... If [User::InitialorMonthly] == 'Initial' SELECT (Everything) ELSE SELECT Based on [ModifyDate] being from the 15th of last month to now...[User::InitialorMonthly] == 'Monthly' I could CASE it out in my T-SQL but if I've already derived…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-04-02T19:15:45.27+00:00
Bobby P 271 Reputation points
commented 2026-04-15T06:25:04.7966667+00:00
Lakshmi Narayana Garikapati 1,310 Reputation points Microsoft External Staff Moderator
1 answer

ETL Framework In Production

Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through the Execute Process Task. I am extracting Data from E2 SQL to Azure SQL Server. The connection has already been established. I am building complete…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2025-10-31T06:27:51.5966667+00:00
Uma 511 Reputation points
recommended 2026-04-13T12:40:48.98+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

SSIS Variable Naming Convention/Standard

I know this is a very loose ended question/request...But just wondering what some of you use as Variable Naming Conventions/Standards when creating and using your SSIS Variables. Just looking for some ideas of what some people and shops use for their…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2025-10-30T21:01:55.1166667+00:00
Bobby P 271 Reputation points
recommended 2026-04-13T12:40:12.33+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
5 answers

How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..

Hi Experts, For the first time, we install New SQL Failover clustering on primary host and it success, however when we tried to install now the SQL on the secondary host as Add node SQL failover cluster, we encountered an error at the beginning of the…

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

3,156 questions
SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

1,371 questions
SQL Server | Other
asked 2023-01-17T12:13:39.11+00:00
Homer Sibayan 366 Reputation points
commented 2026-04-13T05:10:54.2933333+00:00
Jadhav, Rahul (Pune) 0 Reputation points
2 answers

Cannot Deploy SSIS project. Error: Could not load type Microsoft.Internal.VisualStudio.Shell.Interop.IVsCustomTelemetryService from assembly Microsoft.Internal.VisualStudio.Interop PublicKey

I get this error trying to deploy a package after installing VS2026 March 2026 release Version 18.4.2. All though it does deploy the error pops up after every step during deployment. I tried a repair, I tried removing the ComponentModelCache folder and…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2026-03-27T13:39:52.1333333+00:00
Barr, David 10 Reputation points
commented 2026-04-11T15:46:13.4+00:00
Tracy White 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,789 questions
asked 2025-10-22T14:48:38.8733333+00:00
JORYSNIEL MATA NUÑEZ 0 Reputation points
recommended 2026-04-02T09:58:00.78+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Getting errors trying to import data from an SAP Cloud for Customer tenant using OData API in SSIS

Hello, So, I am attempting to import data from an SAP Cloud for Customer (C4C) System into an SQL Server Table using SSIS on Visual Studio 2022. I am using the Odata Source tool to connect to the system and the connection is successful. I can even see…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
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,747 questions
SQL Server | Other
asked 2024-07-18T15:55:39.1166667+00:00
Amogh Sharma 45 Reputation points
answered 2026-04-01T14:12:24.6533333+00:00
Walid AZAK 0 Reputation points
1 answer

Visithttps://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1000.6&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026 to get help on troubleshooting.

I keep getting errors p also cant find terms. I have tried to download many times i am at my braking point

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,789 questions
asked 2025-11-08T16:51:42.1466667+00:00
Mariela Lopez 0 Reputation points
commented 2026-03-31T04:28:53.11+00:00
Akhil Gajavelly 1,820 Reputation points Microsoft External Staff Moderator