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-04T14:32:24.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(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
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
![](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)
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-04T10:59:08.8933333+00:00
Yunus Emre Coşkun
0
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)
2 answers
how to open sql server from visual studio
I 'am traying to open the SQL server 2022 folder after installing visual studio 2026 but the folder that I have for SQL server 2022 is empty folder why?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2026-05-26T22:09:12.9266667+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(115.19999999999999, 61%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEO%3C/text%3E%3C/svg%3E)
elamin osman
0
Reputation points
commented 2026-06-04T07:02:23.0366667+00:00
Lakshmi Narayana Garikapati
1,330
Reputation points Microsoft External Staff
Moderator
1 answer
Can't connect to SQL Server to complete Learning Labs
DataSource.Error: Microsoft SQL: 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…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,747 questions
asked 2026-02-25T22:10:45.2+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, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ammo Parmar
0
Reputation points
commented 2026-06-04T04:54:54.74+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,825
Reputation points Microsoft External Staff
Moderator
1 answer
Security rules violation exception when running subscriptions with SSRS Custom Authentication
I have implemented SSRS Custom Authentication using Microsoft.Samples.ReportingServices.CustomSecurity. Everything works correctly in SQL Server 2022 ReportServer- except for subscriptions. When I add new subscriptions and executed it, I get 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,162 questions
asked 2025-06-26T05:23:56.6233333+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(294.40000000000003, 54%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SAi
10
Reputation points
edited a comment 2026-06-04T04:41:23.3+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
1 answer
SSRS URL certificate renewal
The SQL Server certificate associated with the SSRS URLs will expire on June 26th. A replacement certificate has been installed on the SQL Server, but instructions are needed for correctly binding it to the SSRS URLs. Could you please advise whether…
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 2025-06-23T17:39:41.2266667+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, 25%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gaddam Abhishek Reddy
0
Reputation points
commented 2026-06-04T04:37:38.3733333+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
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,747 questions
1 answer
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…
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 2025-06-02T15:38:53.3733333+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(265.6, 55.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Apostolu, Chris
0
Reputation points
commented 2026-06-04T04:34:40.0466667+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
1 answer
SQL DB not Found
Hi, I have created SQL Server with multiple SQL Database in it, but when I try to click the Database in the Azure Portal, it says Resource Not Found, I can connect to the same database in the SQL Server Management Studio, I have also tried getting the…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2025-04-28T08:46:47.8233333+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, 28.000000000000004%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shabir jan
21
Reputation points
edited a comment 2026-06-04T04:32:44.8833333+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
1 answer
Facing an issue while Export/Backup SQL Database
While taking backup of an existing SQL Database using Export Database option, observed that its taking too much times in hours. After 3-4 hrs as well its showing progress of just 1% only. So want support for the same that what could be the reason behind…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
717 questions
asked 2025-04-14T10:14:50.65+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(249.60000000000002, 37%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gravitive Service
0
Reputation points
commented 2026-06-04T04:30:08.9633333+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
1 answer
Create Crystal report error in Programs files folder .
I have a Crystal report which is having a data source from MS SQL server. I am always getting this error when we want to show the report: Unknown Query Engine Error Error in File C:\Users\ADMINI~1\AppData\Local\Temp\Test.rpt: Unknown Query Engine…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,747 questions
asked 2025-02-10T13:13:27.78+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, 49%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Eduard Kenin
0
Reputation points
commented 2026-06-04T04:26:27.7666667+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,794 questions
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
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
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
717 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,516
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,747 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,747 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