SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
3 answers
SSIS Package Execution Error - The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered
Hello Community, I have been getting this error message every time I run my saved SSIS package. And even though I have looked up this error message across the web, the solutions have not seemed to work. To provide the background information with the…
SQL Server Integration Services
![](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, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
need a query to do a match
Hi all, I have these two tables: T1 Date Item Qty 2025-07-01 100 10 2025-07-01 101 20 2025-07-02 100 30 2025-07-03 200 20 2025-07-04 200 30 and T2 Date Item …
SQL Server | SQL Server Transact-SQL
203 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(236.8, 33%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Getting this error: Msg 3609, Level 16, State 1, Line 88 The transaction ended in the trigger. The batch has been aborted.
So I'm trying an exercise Trigger Code that would send an email if someone tries to insert into the adventure database a special offer that is equal to or greater than 80%, My Code goes Like this: ----------------------- The…
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,504 questions
asked 2021-12-11T12:01:56.03+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, 74%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
salma dodin
96
Reputation points
commented 2025-07-09T16:47:40.3333333+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, 89%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENI%3C/text%3E%3C/svg%3E)
Niarchos Ioannis
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Export Query Results as CSV WITH Headers
I just need to get my query results out to a CSV file WITH Headers quickly (without going through the whole SSIS process for a one-off job). I thought the option below would do the trick, but I get a CSV WITHOUT Headers. Advice?
SQL Server | Other
14,504 questions
asked 2023-03-28T21:32:41.3666667+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, 23%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dom
941
Reputation points
commented 2025-07-09T16:00:10.55+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, 98%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Doug Anderson
0
Reputation points
2 answers
Do Microsoft CSP Annual and Triennial licenses include Software Assurance (SA)?
Do Microsoft CSP Annual and Triennial licenses include Software Assurance (SA)?
SQL Server | Other
14,504 questions
asked 2025-07-04T03:06:34.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(166.4, 72%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kannika_W Warunyaporn
0
Reputation points
answered 2025-07-09T15:22:01.4533333+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, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
78,161
Reputation points
Volunteer Moderator
1 answer
Documentation for CLR-Based Alternatives to xp_cmdshell
Hi Team, Since extended stored procedures are deprecated, is there any source code or documentation available for a CLR-based alternative to Microsoft system-defined extended stored procedures such as xp_cmdshell? Thanks, Abhishek Modi
SQL Server | SQL Server Transact-SQL
203 questions
asked 2025-07-08T06:13:40.6066667+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)
0
Reputation points
commented 2025-07-09T07:52:15.66+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
2 answers
Fresh Win 11 install, I can access network drives, but when I try to connect using Windows Auth to a network database using MS SQL Server I get an error.
When I try to connect to a network database using MS SQL Server (using Window Auth), I get a message stating "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456). I also can no longer remote connect to any of…
SQL Server Database Engine
268 questions
asked 2025-07-07T21:26:47.2166667+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, 1%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Thorsell, Patrick
0
Reputation points
commented 2025-07-08T23:18:49.1+00:00
Thorsell, Patrick
0
Reputation points
4 answers
Transfer SQL server license
Hi, I have installed SQL 2022 (elv vesrion) on a new server. I'm planning to decommission the old server. Before I do that, I need to transfer the license. So, SQL 2019 to SQL 20220 STD What is the best way I can have this done? Thanks in…
Windows for business | Windows Client for IT Pros | Devices and deployment | Licensing and activation
SQL Server | Other
14,504 questions
asked 2024-04-22T04:26:53.8533333+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(0, 60%, 10%)' 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)
Alvish Chand
0
Reputation points
edited an answer 2025-07-08T15:13:34.32+00:00
Bruce (SqlWork.com)
78,161
Reputation points
Volunteer Moderator
1 answer
Setting up SQL Job to Auto Run SSIS Package from Integration Services: Says missing driver
I created an SSIS Package for importing data from Excel to my SQL server. The package, when ran manually from SSMS v17, works. However, when I attempt to do so via a Job within SQL Server Agent in SSMS v20, I get an error message that is the following: …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-07-08T12:17:27.16+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, 5%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Michael DeGrave
0
Reputation points
commented 2025-07-08T12:43:40.3533333+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
2 answers
TF400981: Failed to backup the Reporting Services encryption key.
TF400981: Failed to backup the Reporting Services encryption key. You can try using RSKEYMGMT command to backup the encryption key Completed Verify Backup Encryption Key Operation: Warning
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,066 questions
asked 2022-10-17T11:07:33.09+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, 24%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Pratik Makwana
1
Reputation point
edited an answer 2025-07-08T05:34:24.4266667+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, 26%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pedro Romero
0
Reputation points
1 answer
Power Apps SQL Update Taking Time – Need Help with Efficient Bulk Update via Staging Table and Dynamic SP.
Question: We are currently using Power Apps to perform manual data reconciliation between two tables — let’s say TBL-1 and TBL-2 (as shown in the screenshot below). Our users upload data from Excel via Power Apps and click “Update,” which triggers SQL…
SQL Server | SQL Server Transact-SQL
203 questions
asked 2025-07-07T15:56:38.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(102.4, 76%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dheeraj Singh
0
Reputation points
answered 2025-07-07T20:12:59.29+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
1 answer
Cpackage::LoadFromXML fails
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-07-07T07:39:29.2466667+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, 49%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Teh, Kok Soon
0
Reputation points
edited a comment 2025-07-07T15:42:19.6666667+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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
26,586
Reputation points
1 answer
Microsoft Report Builder UI Issue
Greetings! I would like to ask about the UI issue that I am facing for Microsoft Report Builder. The fields are not aligned. Seems like I have a UI issue. I have already uninstall and install it back. Currently running Version…
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,066 questions
asked 2025-07-07T08:48:37.1033333+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, 65%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Ammar Ibrahim
0
Reputation points
answered 2025-07-07T10:58:25.38+00:00
Olaf Helper
47,516
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Server 2022 Express – “Wait on the Database Engine recovery handle failed” Even After Clean Install
Hi everyone,I'm trying to install SQL Server 2022 Express (16.0.1000.6) on my Windows machine and keep running into the same fatal error, even after multiple clean install attempts: TITLE: Microsoft SQL Server 2022 Setup The following error has…
SQL Server | Other
14,504 questions
asked 2025-07-07T06:47:55.37+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, 81%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYB%3C/text%3E%3C/svg%3E)
Yusuf Bedri Bitiren
20
Reputation points
commented 2025-07-07T08:23:29.1066667+00:00
Yusuf Bedri Bitiren
20
Reputation points
2 answers
How can I implement impersonation on SSRS without prompting the normal user.
How can I implement impersonation (i.e. domain/user) across a domain for all users to use without prompting for user name and password SSRS. I have been trying to modify the configuration files without success. Besides the security risks please can…
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,066 questions
asked 2025-07-02T13:42:15.1733333+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(48, 13%, 14%)' 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)
Mark Askins
0
Reputation points
answered 2025-07-07T08:16:02.0666667+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(48, 28.000000000000004%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
Adelle zieme
0
Reputation points
1 answer
How to setup Azure Automation account to restore database on SQL MI ?
Hello, I have a PowerShell script (see below) that I currently run daily from a task scheduler on a VM to restore a production database (SQL Managed Instance) to a secondary instance (SQL Managed Instance). I am planning to move this process to an Azure…
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,368 questions
Windows for business | Windows Server | User experience | PowerShell
SQL Server | Other
14,504 questions
asked 2024-07-23T20:11:08.8833333+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, 84%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Anoop Noel Nakkala
0
Reputation points
answered 2025-07-06T21:20:44.43+00:00
Amira Bedhiafi
34,336
Reputation points
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Database Migration Assistant Related Queries
Hi There! Could you please help with below queries. Database Migration Assistant for assessment. Does it require internet connectivity on server to run the assessment effectively? I can see in 'Assessment Type' options are 'Database Engine' and…
SQL Server | Other
14,504 questions
asked 2025-07-06T06:11:54.2533333+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(220.8, 11%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chirag Sachdeva
301
Reputation points
commented 2025-07-06T11:59:37.9966667+00:00
Chirag Sachdeva
301
Reputation points
1 answer
SQL SERVER 2022 INSTALL FAILING File activation error on a drive that has never existed on my pc. File activation failure. The physical file name "D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\modellog.ldf"
This is definitely a weird issue. Let me setup the scenario. Just bought a new CyberPowerPC with a AMD Ryzen 5 5500, 3600 mhz, 6 core(s) , 12 logical processors. My issue is with installing SQL server 2022 developer's edition. Checking the error log I…
SQL Server Database Engine
268 questions
asked 2025-07-05T20:09:34.1733333+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(121.6, 68%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kevin miller
0
Reputation points
answered 2025-07-06T08:27:52.88+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
1 answer
Problème d’installation de SQL Server 2022 sur un serveur RDS avec User Profile Disks (UPD)
Je tente d’installer SQL Server 2022 Standard sur un Windows Server 2022 qui héberge déjà les rôles RDS (Remote Desktop Services), avec la fonctionnalité User Profile Disks (UPD) activée. L’installation échoue au niveau du moteur de base de données…
SQL Server Database Engine
268 questions
asked 2025-07-03T15:26:50.9+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, 6%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Charlie GOURDIEN
0
Reputation points
answered 2025-07-04T14:46:45.3466667+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
1 answer
Handling of very long strings
Hi! We are trying to include a (sometimes) very long string into our reports, rendered with SRSS. Due to the nomenclative background of it (ISCN), the string does not contain a lot of spaces, where breaks are able to occur. There are however places we…
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,066 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(86.4, 6%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)