SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
2 answers
SQL Server 2019 → 2022 Migration: Collation Choice and SSISDB Creation Strategy
Hello everyone, We are in the process of migrating our existing DWH and ETL infrastructure from SQL Server 2019 to SQL Server 2022, and we would like to get some advice regarding collation selection. Current System Windows Server 2019 SQL Server…
SQL Server Integration Services
asked 2026-01-12T21:46:40.0133333+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, 97%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOB%3C/text%3E%3C/svg%3E)
Oktay Bozdemir
41
Reputation points
commented 2026-01-21T06:31:33.6866667+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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,125
Reputation points Microsoft External Staff
Moderator
2 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,772 questions
asked 2026-01-12T07:43:28.86+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(80, 77%, 17%)' 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)
Abhishek Modi (amodi)
20
Reputation points
commented 2026-01-21T05:29:14.8033333+00:00
Akhil Gajavelly
1,125
Reputation points Microsoft External Staff
Moderator
1 answer
Applying token authentication to read data from a ZenDesk source in a SSIS 2022 package
Hi, I need to maintain an existing SSIS 2022 package that performs an API call to a ZenDesk source by the removed username and password authentication method, changing this authentication type to token one. Unfortunately, I don't know ZenDesk and I have…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 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(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
Local is 4.8 QA Is 4.5 Prod is 4.8 developing on local. But still on prod not works and gting error. Like cannot upgrade script component. Please help me. Tried with many options and tired. QA is Working and and same package deployed on prod fails
Local .NET is 4.8, QA Is 4.5, Prod is 4.8. changed 2 columns lengths in SSIS and not any major changes. developed on local But still on prod not works and giving error Like cannot upgrade script component. Please help me. Tried with many options and…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-09-13T06:17:50.0066667+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(64, 38%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
ram naveen
0
Reputation points
recommended 2026-01-19T18:02:28.6333333+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(227.2, 39%, 32%)' 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)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
SSIS error
Good morning everyone, I'm getting the following error [Execute SQL Task] Error: Executing the query "DECLARE @ReturnCode INTEGER = 0; [Execute SQL Task] Error: Executing the query "DECLARE @RerurnCode INTEGER = 0; excute ? OUTPU..."…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-11-25T18:27:45.5966667+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,881
Reputation points
recommended 2026-01-19T18:00:18.67+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
SQL 2022 SSIS with ACE 12 32bit error unexpected Termination
Hi We had a set of SSIS package on SQL 2016 writing the output to Excel with different tabs. In the old server we have ACE 2010 version 14 32bit. We had to upgrade our servers to Windows 2022 SQL 2022 we installed ACE 16 32bit but when running the SSIS…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-09-14T08:49:48.7566667+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(102.4, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Katayoun Sarab
0
Reputation points
recommended 2026-01-19T17:30:09.52+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server 2022, Visual Studio 2022 - Microsoft VB 2022 script task interacting with Excel COM Errors
We have some SSIS packages that interact with Excel files. The SSIS packages output the data to the excel spreadsheets that include a template row so that numbers are formatted as numbers.. etc. There are also pivot tables that exist on other tabs of…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-10-31T20:27:55.9566667+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(83.2, 52%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Guilfoy, Kristy
20
Reputation points
recommended 2026-01-19T12:23:09.8333333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Excel Connection Manager not working on a 64-bit Client
For the life of me I cannot get an Excel Connection Manager to work in SSIS. Could not retrieve the table information for the connection manager 'Excel Connection Manager'. Failed to connect to the source using the connection manager 'Excel Connection…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-10-30T19:23:54.81+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
recommended 2026-01-19T12:22:49.59+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Connection string
Hello, I have a connection string which works on the old production server but doesn't work on the new production server. <?xml version="1.0"?> <DTSConfiguration> <DTSConfigurationHeading> <DTSConfigurationFileInfo …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-10-28T16:55:24.61+00:00
Naomi Nosonovsky
8,881
Reputation points
recommended 2026-01-19T12:22:01.34+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Build errors while adding SQL Server 2025 (Version - 17.x)
Hi Team, I have installed SQL Server 2025 (Version 17.0.1000.7), and I am updating a project to add support for SQL Server 2025. For this, I need two processor architecture MSIL assemblies: Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SqlEnum.dll,…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2026-01-12T15:16:17.6266667+00:00
Abhishek Modi (amodi)
20
Reputation points
commented 2026-01-19T11:54:11.81+00:00
Abhishek Modi (amodi)
20
Reputation points
1 answer
Upgraded VS to version 16.11.49 but now my original SSIS package is not appearing
Hi I updated VS to version 16.11.49 but now my original SSIS package is not available. I can create new SSIS package but I cannot access my original one. Below are some screenshots: Message I get when I open my original SSIS package: SSIS is…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-07-17T04:03:25.14+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(9.6, 62%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Manny
151
Reputation points
recommended 2026-01-19T08:53:06.1733333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
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,772 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
recommended 2026-01-19T08:47:19.2733333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Attunity drivers are failing after OS upgrade to 2022
we have ssis packages where target is sql server 2016 and os 2016. recently we upgraded server os to 2022 but the sql server is still 2016. after upgrade the packages which are using attunity drivers to connect to oracle are failing when we give password…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2026-01-06T16:10:32.53+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(160, 98%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
vamsi krishna
0
Reputation points
commented 2026-01-19T05:15:33.11+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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
670
Reputation points Microsoft External Staff
Moderator
1 answer
SSIS Job Failing Due to MongoDB Driver Dependency Error After MongoDB 8 Upgrade
As part of an ongoing upgrade to MongoDB version 8, we are updating the C# components used to integrate data into MongoDB collections to ensure compatibility with the latest MongoDB driver syntax and APIs. During this upgrade, we are encountering a…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2026-01-06T15:16:26.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(278.4, 50%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sahar Aitlhou
0
Reputation points
commented 2026-01-19T05:14:44.99+00:00
Lakshmi Narayana Garikapati
670
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,772 questions
asked 2026-01-14T21:46:11.5966667+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(198.4, 83%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
mohmaed ahmed mohamed rahmo
0
Reputation points
answered 2026-01-14T22:18:50.9933333+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
1 answer
Require Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SqlEnum.dll MSIL DLL which matches released version of SQL Server 2025 (V - 17.0.1000.7)
Hi Team, I am updating a legacy (.NET Framework 4.7.2) project to support SQL Server 2025 (v17). Our code depends on Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SqlEnum.dll version 17.0.1000.7, processorArchitecture=MSIL. However, after…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2026-01-13T07:59:44.8933333+00:00
Abhishek Modi (amodi)
20
Reputation points
commented 2026-01-13T22:31:47.85+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
3 answers
Choosing Between SQL Server/SSIS 2022 and 2026 — Which Version Is More Stable for Enterprise Use?
Hello, We are a DWH team running our ETL processes using SSIS packages. Our ETL packages are executed on SQL Server via SQL Server Agent jobs, and all ETL development is done in Visual Studio. Our current environment consists of: Windows Server 2019 …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-12-23T21:31:26.1866667+00:00
Oktay Bozdemir
41
Reputation points
edited the question 2026-01-13T09:33:09.4633333+00:00
Oktay Bozdemir
41
Reputation points
3 answers
Is there any ongoing issues with SQL when trying to just change the column type via SSMS
When trying to change a column config from nvarchar(10) to nvarchar(200) the SSMS throws an timeout error when saving the change. The table is not a big one, just 40k rows. I have tried to change the Transaction time from default 30 secs to 120 secs, but…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-11-07T08:32:57.2733333+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(112.00000000000001, 8%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Aleksi
0
Reputation points
recommended 2026-01-12T08:38:01.95+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-09-15T11:05:58.73+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(278.4, 42%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
NAEEM AKRAM
0
Reputation points
recommended 2026-01-12T08:33:43.6966667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
SSIS: Create output file with specific name and a footer
Good day, I have the following requirements - create a daily file with the filename in the pipe delimited format using name like 'PDMAutomation_yyyy_mm_dd.txt. Also this file needs to have a footer, e.g. source|request_type|change_type|Other…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-08-05T15:38:32.3233333+00:00
Naomi Nosonovsky
8,881
Reputation points
recommended 2026-01-12T08:30:47.8333333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator