SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,794 questions
1 answer
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
SQL Server Integration Services
asked 2026-06-02T08:02:08.6133333+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, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Urbel
605
Reputation points
commented 2026-06-04T04:03:30.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(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepesh Dhake
80
Reputation points
1 answer
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…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,794 questions
asked 2026-06-03T03:55:34.95+00:00
Ali Ahad
151
Reputation points
commented 2026-06-04T03:50:16.0833333+00:00
Deepesh Dhake
80
Reputation points
1 answer
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 …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,794 questions
asked 2026-06-03T20:17:02.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(195.2, 92%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Igor Gelin
0
Reputation points
commented 2026-06-04T03:35:32.5+00:00
Deepesh Dhake
80
Reputation points
3 answers
One of the answers was accepted by the question author.
Setup issue to SQL Server Management studio installer 22
Hi, When doing the setup of SQL Server Management studio installer 22 on Windows server 2025, I got "internet connection, and not able to do the download". How to find out the issues on the server for this?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,746 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(316.8, 97%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
2 answers
Upgrading SQL 2019 to 2025 - Fulltext index issue
When doing a SQL server upgrade from 2019 to 2025, im running into an issue when it is trying to finalize the Fulltext index part of the upgrade. It seems like the upgrade locks itself out of the upgrade, by putting permissions on the Filterdatafolder,…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,746 questions
asked 2026-06-03T07:09:59.9033333+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(28.799999999999997, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYE%3C/text%3E%3C/svg%3E)
Yunus Emre Coşkun
0
Reputation points
commented 2026-06-03T19:25:41.3166667+00:00
Erland Sommarskog
134.4K
Reputation points MVP
Volunteer Moderator
2 answers
Upgraded sql server from sql 2016 to sql 2022, but master database still at 130 level. Should i change it ?
We upgraded sql server from sql 2016 to sql 2022, but master the database still at 130 compatibility level level. I get why the upgrade process needs to keep the master database at 130 level. Post upgrade, should we manually change the compatibility…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
715 questions
asked 2026-06-03T08:08:57.19+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(230.39999999999998, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Greg Booth
1,496
Reputation points
answered 2026-06-03T19:11:21.2866667+00:00
Erland Sommarskog
134.4K
Reputation points MVP
Volunteer Moderator
1 answer
# SQL Server 2022 Availability Group works in Workgroup but fails in Active Directory environment Hello everyone, I am currently learning SQL Server administration and I am doing a practical lab as part of my internship. I would appreciate some guidance
Hello everyone, This is my first time posting on this forum, so please excuse me if I miss any forum conventions or provide too much or too little information. I am currently learning SQL Server administration and I am doing a practical lab as part of my…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,746 questions
asked 2026-06-03T15:26:53.8433333+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(92.8, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Eurly Garcia LOUP LOCKO
0
Reputation points
commented 2026-06-03T19:03:17.1866667+00:00
Erland Sommarskog
134.4K
Reputation points MVP
Volunteer Moderator
4 answers
varchar vs nvarchar
as a general rule, should you use varchar instead of nvarchar, if you won't ever be storing foreign language characters?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,746 questions
asked 2021-01-19T00:32:57.113+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(217.60000000000002, 37%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
SQL Guy10
1
Reputation point
commented 2026-06-03T15:26:55.8866667+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(268.8, 54%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Janusz Snieg
0
Reputation points
1 answer
Error trying to use latest SQL Server Migration Assistant for Access
I have the latest SSMA for Access installed but can't get past a "New Workspace Error" either via the start wizard or trying to open a solution I created about 9 months ago. The error states "The type initializer for…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
606 questions
asked 2025-06-17T11:07:16.47+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(224.00000000000003, 87%, 31%)' 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)
Kevin Seerup
0
Reputation points
commented 2026-06-03T06:07:26.5933333+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
1,330
Reputation points Microsoft External Staff
Moderator
3 answers
The long running select statement blocked the insert/update statement
The long running select statement blocked the insert/update statement execution Scenario: We have the multi-thread batch insertion logic to insert data to MSSQL database. When the insertion logic was executed, some users execute a long running select…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
715 questions
asked 2026-05-08T06:42:51.8466667+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(16, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sam Chung
0
Reputation points
recommended 2026-06-03T05:42:42.3+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
SQL Server 2022 Express installation error -2061893606 and service error 1067
Hello, I have a problem installing Microsoft SQL Server 2022 Express for EBP Gestion Commerciale ELITE 2025. Errors: Error -2061893606 SQL Server service (EBP) cannot start Error 1067 Shared Memory Provider, error: 40 What I already tried: …
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
715 questions
asked 2026-05-14T10:18:59.6533333+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, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Youssef Maach
0
Reputation points
recommended 2026-06-03T05:32:30.5966667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
how to fix physica; sector size when PC has m.2 drives
LargeSectorSizeCheck Checks whether any disk intended for SQL Server data has a physical sector size greater than 4 KB, which is currently unsupported. Warning One or more disks intended for SQL Server data have a physical sector size greater than 4 KB.…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
715 questions
asked 2026-05-12T11:49:12.42+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(124.80000000000001, 41%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Peterson Gideon
0
Reputation points
recommended 2026-06-03T05:31:50.34+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server Audit / Extended Events – Role‑based (sysadmin) filtering limitations
Hello Microsoft Team, We are implementing security monitoring for sysadmin account usage on an on‑premises SQL Server instance and would like to know what EX events or Audit to achieve our goal? We tried Audit and XE events but those are capturing all…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
715 questions
asked 2026-04-24T17:19:09.7+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(44.800000000000004, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUP%3C/text%3E%3C/svg%3E)
Uday Paleti
5
Reputation points
recommended 2026-06-03T05:19:03.61+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
How can i install SQL server 2025 on AppVolume/Appstack VM
Hi EveryOne How are you? I like to install SQL Server 2025 + SSMS on AppVolume/Appstack(win 10) VM for all my users/VDIs in my organization. How can I do that? Is it possible? I know SQL server it is heavy software Thanks Michael
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,746 questions
asked 2026-04-03T12:35:31.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(272, 51%, 36%)' 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)
Michael39
0
Reputation points
recommended 2026-06-03T05:18:43.99+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Sql Server 2025 Updated Application working Slow
Application have been running really slowly since upgrading the database to SQL Server 2025.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
715 questions
asked 2026-05-07T07:36:42.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(310.4, 8%, 40%)' 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)
Ab Malik
0
Reputation points
recommended 2026-06-03T05:18:23.5666667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
how to sucessfully connect sql Smm server profile to database engine?
i tried connecting sql 2025 model of server profiler 22 in my system of DESKTOP-UL2OACD BUT its showing TITLE: Connect to Server Cannot connect to DESKTOP-UL2OACD\iwunor kelechi. ADDITIONAL INFORMATION: A network-related or instance-specific error…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
715 questions
asked 2026-05-02T14:05:18.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(288, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Iwunor kelechi
0
Reputation points
recommended 2026-06-03T05:17:43.25+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
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,794 questions
asked 2026-04-29T06:12:42.41+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(268.8, 34%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIR%3C/text%3E%3C/svg%3E)
Ishika Raiyani
20
Reputation points
recommended 2026-06-03T05:17:06.2333333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
ERROR 1067
I'M GETTING AN ERROR MESASGE 1067 WHEN I TRIED INSTALLING A PROGRAM. a SQL IS NOT STARTING. I TRIED STARTING IT IN THE SYSTEM ANDTHAT DID NOT WORK.
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,746 questions
asked 2026-04-28T18:24:02.25+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(99.2, 91%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dan Kilpatrick
0
Reputation points
recommended 2026-06-03T05:16:37.1133333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Erro na instalação do SQL Server 2025 express - Exit Code-2061893606
Prezados, Estou enfrentando um problema recorrente ao tentar instalar o Microsoft SQL Server 2025 Express Edition em meu computador com Windows 11. Durante o processo de instalação, o setup falha com a seguinte mensagem: Exit code (Decimal):…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
715 questions
asked 2026-04-25T17:49:50.47+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(176, 92%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Joao Beluso
0
Reputation points
recommended 2026-06-03T05:16:19.8266667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server Developer Edition – Request for Formal Clarification on Usage Restrictions and Boundaries
We are requesting formal clarification at an organisational level regarding the licensing limitations and permitted use of SQL Server Developer Edition, to support corporate governance and audit compliance. To ensure correct interpretation and consistent…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,746 questions
asked 2026-04-23T10:59:24.18+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, 11%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mohammad Sultan: H&F
0
Reputation points
recommended 2026-06-03T05:15:03.4333333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator