2,796 questions with SQL Server Integration Services tags
SQL Agent job step "Dump on errors" produces no output
I have a SQL Server Integration Services Package agent job step that is failing with an "Unexpected termination". To help diagnose what's going on, I've selected the "Dump on errors" flag of the Configuration/Advanced tab. However…
Download SFTP files using ssis
I have files sitting in an SFTP location and I am trying to bring them to a shared drive using SSIS. The problem with SSIS is that it has a task for FTP but not for SFTP. Here is what I did for now. I created an SSIS Package and used an…
Derived column truncation error
I am getting following truncation error message in the derived column transformation: The "Derived Column" failed because truncation occurred, and the truncation row disposition on "Derived Column.Outputs[Derived Column…
Test connection failed because of an error in initializing provider. The given key was not present in the dictionary.
I am getting this error VS2022 and VS2026 when tried to create a connection from ssis project with connection manager. SQL server version is Microsoft SQL Server 2022 (RTM-GDR) (KB5073031) - 16.0.1165.1 (X64) Nov 24 2025 19:08:45. It was working…
A script transformation in SSIS 2016 doesn't upgrade to SSIS 2022
Hi All, I created an SSIS 2016 ETL. The ETL has a script transformation in a data flow. Merged the ETL with the SSIS 2022 solution. Upgraded the ETL to 2022 in Visual Studio 2022. Reviewed the upgrade report: ========== The Upgrade is Successful …
How to install SSIS Packages on Availability Always On?
Hi expert , my organization plan to provide SSIS package on High Availability server ( Availability Always On) how can I do it? Great Appreciation for all answer warm regards Urbel
Confirmation on Maintenance Plan DLL Usage for SQL Server 2025
Hello Team, Earlier, till SQL Server 2022 (version up to 16) we were compiling our Maintenance Plan source code project by referencing the required DLLs from the GAC. However, for SQL Server 2025 (version 17), based on our analysis of the…
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…
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…
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…
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…
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 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…
Is SQL EXPRESS GAMP5/GxP and CFR 21 Part 11 compliant?
Hello everyone, I am about to use SQL in a regulated environment which means that it has to be GMAP5/GxP & CFR 21 Part 11 compliant. Is SQL EXPRESS GAMP5/GxP & CFR 21 Part 11 compliant or do I have to use the SQL Standard Verison? Thank you in…
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…
How do I add Import/Export to SSMS 22?
I've downloaded and added SMSS 22 to my computer but still need the Import/Export features. How do I add them easily?
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:…
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…
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…
I'm using SQL Server 2025, with SSMS V22.5.2, and the Maintenance Plan Wizard is grayed out.
I'm running into the problem of the SQL Server Maintenance Plans options being grayed out. I've gone thru the "common reasons" for this and eliminated those issues. I'm using SQL Server 2025 Standard, V 17.0.1110.1, with SSMS V22.5.2. SSIS,…