SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,794 questions
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
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-04T19:53:35.01+00:00
Igor Gelin
0
Reputation points
3 answers
locking issue in MSSQL
Issue: the holdlock script has locking the multi-thread(10) insert/update We would like to revise the multi-thread script to from (HOLDLOCK) to (UPDLOCK, SERIALIZABLE) Original script: MERGE testtable WITH (HOLDLOCK) AS t USING (SELECT @P0 hjmpTS, @P1…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2026-05-20T07:28:48.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(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-04T19:12:33.0966667+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
2 answers
Distribution Cleanup Job Failing Silently in SQL Server 2019 Transactional Replication Causing Distribution DB Growth to 1.5 TB
Hello All, We are facing an issue with SQL Server Transactional Replication where the Distribution Cleanup job has been failing silently, and the distribution database has grown to approximately 1.5 TB, causing severe disk space issues. Environment SQL…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,747 questions
asked 2026-05-16T08:14:26.1766667+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(252.8, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Parag Nimbhore
5
Reputation points
recommended 2026-06-04T19:12:11.9066667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Express ODBC Connection
Hi, I am trying to connect UPS WorldShip to a SQL server to pull shipping data. It keeps telling me the connection has failed, this is a replacement server, the old server still connects. I turned off the firewall on the server for testing, I…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,747 questions
asked 2026-05-13T11:23:01.49+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(67.2, 39%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Brian Branco
0
Reputation points
recommended 2026-06-04T19:11:44.99+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
sql server migration assistance oracle - accidently select always "words" while creating report. Need a report in HTML
accidently select always "words" while creating report. I need to create report in HTML How to reset this feature
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 2026-05-02T17:40:15.46+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(262.40000000000003, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hussain, Baqir
0
Reputation points
recommended 2026-06-04T19:11:28.0066667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Facing issue in loading Report which contains Main and Sub report using Report builder in SSRS
we are working on SSRS Reporting using Report builder. we have a report which has a sub report in it which works well in Production Environment. The same report (RDL file) doesn't load anymore in QA Environment. after waiting 25-30 min, it shows error…
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,162 questions
asked 2026-05-08T07:20:52.6766667+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(166.4, 1%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Madani, Ramya Krishna
0
Reputation points
recommended 2026-06-04T19:10:59.6666667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Claim space for TempDB on Sql Server
Dear Team, Dose Someone kindly advise how to shrink teamdb with effective way without affect Database Service ?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2026-05-06T03:12:42.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(201.6, 41%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
Veasna Lay
0
Reputation points
recommended 2026-06-04T19:10:47.9133333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Mssql Log Shipping Requirement
I want to know about Mssql Log Shipping requirement to make it and the setup in details
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,747 questions
asked 2026-05-04T02:05:32.8966667+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(291.2, 2%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
David Prodata
80
Reputation points
recommended 2026-06-04T19:10:13.5566667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
How to activate SQL 2025 license on SQL2022
Hello i bought "SQL Server 2025 Standart sürümü Kalıcı 1 Sunucu Lisansı ve CAL 10".Before i bought this license, i talked with two microsoft sale representative. They confirm that i can use this SQL 2025 license on SQL 2022. But when i try to…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,747 questions
asked 2026-04-28T08:19:07.6033333+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, 78%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Batuhan Demirkiran
0
Reputation points
recommended 2026-06-04T19:09:55.18+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Alternative to UNION
I have a UNION Query that is combining information from a History Table and the current Master Table. We are talking about a few million rows here. The problem is the amount of [tempdb] space it is allocating and using for the UNION. So we thought if we…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
283 questions
asked 2026-04-22T20:14:11.0866667+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
271
Reputation points
recommended 2026-06-04T19:09:07.2433333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Sql server 2025 installation error
Hello Microsoft Support Team, I am reaching out regarding an installation issue with Microsoft SQL Server 2025 (Express Edition) on my ASUS TUF Gaming A15 laptop running Windows 10 Home Single Language (Build 26200). During installation, the server fails…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2026-04-20T17:33:12.6733333+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(131.20000000000002, 98%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
sanjay MN
0
Reputation points
recommended 2026-06-04T19:07:28.67+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server Login Failures (Error 18456) due to Reporting Services attempting to access non-existent ReportServer database
We are experiencing repeated SQL Server login failures (Event ID 18456) on one of our servers. Details: SQL Server Version: SQL Server 2016 Error Message: "Login failed for user 'REA\IND-WBN-DEV$'. Reason: Failed to open the explicitly specified…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2026-04-17T07:24:16.13+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, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Kamarur Rama
0
Reputation points
recommended 2026-06-04T19:07:15.7866667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Unable to install micrsoft sql server
Unable to install sql server, there is some installtion of previous version is present so unable to install microsoft sql server 2019
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2026-04-13T06:57:25.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(64, 25%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Akshay Hebbar
0
Reputation points
recommended 2026-06-04T19:06:49.3033333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
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,794 questions
asked 2026-04-02T19:15:45.27+00:00
Bobby P
271
Reputation points
recommended 2026-06-04T19:05:55.45+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
Prevent a thick-client app's Windows user from accessing the local SQL Express DB outside the app
Setup: A Windows desktop app runs on non-admin workstations. It uses a local SQL Server Express instance on the same machine over shared memory. The app connects to SQL using the logged-in Windows user's own identity (the app process runs as that…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2026-06-04T13:03:09.61+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(297.6, 30%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mansoor R
0
Reputation points
answered 2026-06-04T18:54:50.8033333+00:00
Erland Sommarskog
134.4K
Reputation points MVP
Volunteer Moderator
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,747 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-04T18:37:47.97+00:00
Erland Sommarskog
134.4K
Reputation points MVP
Volunteer Moderator
2 answers
Power BI Desktop "Cannot establish connection" - msmdsrv.exe listening but connection timeout
Hello, I'm experiencing a persistent issue with Power BI Desktop failing to start. The error message is: "Cannot establish connection. Please verify that the server is running." Environment OS: Windows 11 Pro (10.0.26200) Hardware: Intel…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,747 questions
asked 2026-06-02T13:27:29.3566667+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(304, 62%, 39%)' 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)
兴烨 姚
0
Reputation points
answered 2026-06-04T17:42:40.1233333+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
SQL vs NoSQL Databases: Key Differences and Use Cases
What is the difference between SQL and NoSQL databases, and when would you choose each?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,747 questions
asked 2026-06-04T06:30:54.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(204.8, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Shafique Mulla
0
Reputation points
answered 2026-06-04T10:36:51.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(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
1 answer
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…
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-05-25T14:13:00.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(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-06-04T10:12:35.97+00:00
Abhishek Modi (amodi)
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Logon issue
Hi, Can you help to this? A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 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)