SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,663 questions
1 answer
Unable to update connection credentials. Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller
facing issue with connecting sql server to power bi service, in desktop this is working properly and also able to refresh but in service getting error.
asked 2025-03-11T04:29:49.5633333+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(259.20000000000005, 99%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Nirmala Jawalkar
0
Reputation points
answered 2025-03-12T01:55:57.26+00:00
LiHongMSFT-4306
31,081
Reputation points
8 answers
SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services
Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…
asked 2023-02-20T09:37:55.24+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, 97%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Alessandro Di Pasquale
15
Reputation points
commented 2025-03-11T23:42:14.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(48, 52%, 14%)' 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)
Kim Scott
0
Reputation points
1 answer
One of the answers was accepted by the question author.
SSIS XML write file task - how to preserve empty values?
Hi, We have SSIS package that writes XMLs into files. We have stored procedure that generates XML and outputs it as XML with tags like this <MiddleName> </MiddleName>. In other words, there is a space (intentional) inside the tags. We have…
asked 2025-03-10T21:32:16.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(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,291
Reputation points
edited a comment 2025-03-11T21:30:32.6333333+00:00
Viorel
120.4K
Reputation points
5 answers
One of the answers was accepted by the question author.
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
asked 2024-04-19T14:09:09.57+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(128, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thomas Davies
30
Reputation points
commented 2025-03-10T19:36:40.0933333+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,471
Reputation points
3 answers
Connecting to the Integration Services service on the computer "WIN-5U5BLQJ45G3" failed with the following error: "Class not registered".
I follow the tutorial for SQL Server 2019 Standard Edition at https://learn.microsoft.com/en-us/sql/integration-services/lesson-3-3-testing-the-deployed-packages?view=sql-server-ver15 However, I received the error below while connecting to the…
asked 2024-11-01T07:59:30.0333333+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(150.4, 90%, 24%)' 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)
Nur Izzati Binti Rosli
1
Reputation point
commented 2025-03-10T16:31:05.57+00:00
Tom Boring
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Restore is shutting the sql server down.
In the past when ever I restored the training system with backup of our production SIS I had to turn off the service and shut down the application pool or the restore would not be able to lock the DB's. Today I accidentally started the restore process…
asked 2025-03-05T23:48:45.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(163.2, 73%, 25%)' 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)
John Steele
41
Reputation points
answered 2025-03-06T23:02:37.2033333+00:00
Erland Sommarskog
119.3K
Reputation points MVP
2 answers
Download Writers for SQL 2017
In my environment I am running backups on my SQL 2017. The backup is failing due to SQL VSS writers. The service is present but still doesn't work when running and after restarting. I went to look at vssadmin list writers in elevated command prompt, SQL…
asked 2025-03-04T14:29:15.2333333+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, 64%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
shana bright
0
Reputation points
commented 2025-03-05T20:31:31.0166667+00:00
shana bright
0
Reputation points
5 answers
One of the answers was accepted by the question author.
SSIS Script Task - Edit Script not working
This is a common recurring issue on Microsoft SSIS Projects development IDE on Visual Studio Community 2019 (Windows 10): given a Script Task the edit button that should open a Visual Studio Intance (VSTA) to work on C# code do not react to the click.…
asked 2022-09-30T12:21:07.24+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, 8%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Paolo Cos
31
Reputation points
commented 2025-03-05T15:09:53.5466667+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, 56.00000000000001%, 20%)' 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)
Román Pérez Contreras
0
Reputation points
1 answer
Updates to Microsoft Drivers for PHP for Microsoft SQL Server
Hi, can anyone give an update on the project here https://github.com/microsoft/msphpsql As outlined in the github issue below, there has been no activity on what I believe might be a simple fix to keep the drivers provided up to date with the latest…
asked 2025-03-04T14:57:27.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(182.40000000000003, 51%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bob Murdoch
40
Reputation points
answered 2025-03-05T02:26:17.31+00:00
ZoeHui-MSFT
41,291
Reputation points
2 answers
DBNETLIB error when trying to export my CRM database via SMSS. Need help troubleshooting, please
Alright so, all I want to do is export a CRM database. I've already tried allowing SMSS through the firewall, no dice. I've taken screenshots of my process and hyperlinked them to the steps below to clarify what I'm up to. I connect to CRM via SMSS. I…
asked 2025-03-03T21:09:27.54+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, 39%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
blueHope202
5
Reputation points
commented 2025-03-04T22:04:21.77+00:00
Erland Sommarskog
119.3K
Reputation points MVP
0 answers
How to connect SQL SERVER to ADF using SHIR, It gives some firewall error tried to clear it but I am not able to connect it yet.
I am trying to link my SSMS account to my Azure using SHIR, but when I try to load a table in Azure its giving me an error message which says " Please contact SQL server team for further support. Server: 'DILEEPPC\SQLEXPRESS', Database:…
asked 2025-03-01T22:10:46.0233333+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, 21%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
saidileep yamani
0
Reputation points
commented 2025-03-02T10:31:15.89+00:00
Erland Sommarskog
119.3K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
How to get in touch with someone regarding Azure SQL
I would love to speak to somone regarding: Microsoft Entra authentication
asked 2025-02-28T16:00:28.92+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, 93%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Antonioo Ferri
20
Reputation points
accepted 2025-03-01T06:33:46.6366667+00:00
Antonioo Ferri
20
Reputation points
1 answer
Unable to access SQL over VPN
We have an on-premises Active Directory with Azure AD synchronization (ie: a hybrid environment). Our on-prem includes two separate AD forests that are connected with a two-way trust. For name sake, i'll call these: AD1.local and AD2.local. All client…
asked 2025-02-27T12:04:55.5+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(105.60000000000001, 90%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Philip Preece
41
Reputation points
answered 2025-02-28T09:02:26.6666667+00:00
Philip Preece
41
Reputation points
1 answer
One of the answers was accepted by the question author.
Compatibility Issues Power BI Desktop / SQL (version mismatch?)
Hello, I am working on building a set of SharePoint sites, each will have a dashboard generated by Power BI (source of data -> ERP: Vista from Viewpoint) While testing the connectivity of Power BI Desktop using the most recent version (v…
![](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(60.8, 34%, 15%)' 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)
0 answers
always encrypted with secure enclave not working for DETERMINISTIC in JDBC
I'm using commercial Azure SQL, the database created via the portal, with secure enclaves enabled. I created the CMK and CEK using MSSQL_JAVA_KEYSTORE with keystore jks file. when using jdbc to test query for like and =, if the encrypted column is of…
asked 2025-02-24T12:03:24.69+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, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
John Woo
20
Reputation points
commented 2025-02-26T22:09:11.99+00:00
Erland Sommarskog
119.3K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
How to enable dark mode
How to enable dark mode in SSMS？ I could not find the option to do that.
![](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(12.8, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
0 answers
SSMS Not allowing me to filter Databases
Hi. I am running a SQL EXPRESS Server on SSMS 2018. Normally on other VMs I can filter by Database Name, on this server which is my new main server, that option is greyed out with no reason why. I currently cannot find any resources that explain why!
asked 2025-02-25T16:18:04.6933333+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(313.6, 25%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Huxley Kendell
5
Reputation points
commented 2025-02-26T01:38:58.88+00:00
ZoeHui-MSFT
41,291
Reputation points
1 answer
One of the answers was accepted by the question author.
Fail to install sql 2022
FFail to install sql server2022 dev on my machine. I have install and reinstall for several times. It always said that error corrupted.
2 answers
SQL Server 2022 error when downloading – taking more than 24 hours and still not resolved!
From my research, it seems that everyone is facing this issue, yet there is still no solution. I’m not sure what Microsoft is waiting for to fix this problem. I have completely uninstalled and reinstalled it, but I keep encountering the same issue. I…
asked 2025-02-21T15:45:18.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(304, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
James Flush
0
Reputation points
commented 2025-02-24T21:44:05.29+00:00
Erland Sommarskog
119.3K
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
SSIS An error occurred while attempting to perform a type cast.
The SQL Server has been updated to SQL 2022 (compatibility mode 150). The same file that works in production, now gives an error in Stage Error: 0xC0049064 at Load Flat File, Derived Column File [2]: An error occurred while attempting to perform a type…
asked 2025-02-20T16:35:43.11+00:00
Naomi Nosonovsky
8,291
Reputation points
accepted 2025-02-21T11:46:26.7+00:00
Naomi Nosonovsky
8,291
Reputation points