SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,234 questions
2 answers
Visual Studio Community Integration Services and Licensing
Hello, My questions probably been asked before but I need to be sure and would like to know, what is the difference using community and enterprise version? Let say i have a limited resource , what if I purchase SQL Server License, made a SSIS package…
SQL Server
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,622 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
237 questions
asked 2024-12-30T13:23:51.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(144, 45%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
Rino Yaohari
0
Reputation points
commented 2024-12-31T06:26:24.11+00:00
ZoeHui-MSFT
39,111
Reputation points
2 answers
Enabling OAuth 2.0 for SQL Server Database Mail System
Hello Team, I previously encountered an issue with sending emails from SQL Server where I received an authentication error due to basic authentication being disabled. The team suggested implementing OAuth 2.0, but I struggled to find proper articles or…
asked 2024-12-26T10:43:38.2233333+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(32, 8%, 13%)' 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)
Avinash
20
Reputation points
edited the question 2024-12-30T22:13:28.4633333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
0 answers
MSSQL 2022 - SSISDB ETL returning "...failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. "
Full error from the Integration Catalog in question: SQL Load Queue List into Object:Error: Executing the query "EXEC [My PROC name]" failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to…
asked 2024-12-26T16:44:24.62+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(140.8, 57.99999999999999%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
Fred Bartley
0
Reputation points
commented 2024-12-30T16:28:35.4366667+00:00
Fred Bartley
0
Reputation points
1 answer
One of the answers was accepted by the question author.
ssis develop with VS2019
Where can i download VS2019 to design my ssis2019 package？
asked 2024-12-30T07:57:20.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(86.4, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ2%3C/text%3E%3C/svg%3E)
Jefferson-2765
546
Reputation points
accepted 2024-12-30T08:32:12.9933333+00:00
Jefferson-2765
546
Reputation points
6 answers
Error Fix (Database engine service failed in sql server 2022 and 2019)
Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…
asked 2022-11-23T00:01:59.227+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, 54%, 16%)' 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)
Nelson Nwachia
56
Reputation points
commented 2024-12-27T03:30:44.9066667+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, 38%, 21%)' 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)
Kunal Singh
0
Reputation points
0 answers
SQL Server Enterprise 2019 not core 21 up to
Currently, I am using Windows Server 2016 and SQL Server Enterprise 2019, but the SQL system only utilizes 20 cores, even though I have allocated 60 cores to the server. I have tried the following commands: EXEC sp_configure 'affinity mask', 0; EXEC…
asked 2024-12-26T04:30:18.3066667+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(307.2, 61%, 39%)' 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)
Nguyen ngoc giang
0
Reputation points
commented 2024-12-26T09:29:49.33+00:00
Erland Sommarskog
114.6K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Unable to Send Emails from SQL Server
There is an issue with sending emails from SQL Server, accompanied by the following error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2024-12-03T11:05:46). Exception Message:…
asked 2024-12-23T08:38:01.5766667+00:00
Avinash
20
Reputation points
commented 2024-12-23T11:44:18.4133333+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, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar M
75
Reputation points
2 answers
One of the answers was accepted by the question author.
How to share my SHIR (Self Host Integration Runtime) service with different azure services
I have created a SHIR service for my Azure Synapse Analytics service where I used to perform data operation from Azure Synapse to my On prem SQL Server using my SHIR service. However I wanted to use the data of my on prem SQL with Azure data factory…
asked 2024-12-17T07:34:57.5166667+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(144, 81%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sayeed Ahmed
20
Reputation points
accepted 2024-12-19T13:24:09.3+00:00
Sayeed Ahmed
20
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server 2022 installation error- Cannot find the path specified
I am trying to install MS SQL SERVER 2022 in my Windows 11 hp laptop. Getting this error Unable to install SQL Server (setup.exe). Exit code (Decimal): -2147467259Error description: The system cannot find the path specified i tried express installation…
asked 2024-12-02T08:28:57.62+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, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ashutosh Kumar Yadav
20
Reputation points
commented 2024-12-18T22:11:30.5533333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
6 answers
SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…
asked 2021-11-19T14:32:00.537+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(240, 41%, 33%)' 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)
Alex Fletcher
61
Reputation points
commented 2024-12-18T20:37:05.5866667+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(316.8, 43%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Cassandra Lopez
0
Reputation points
1 answer
Trying to connect to the Fabric Lakehouse from the SSIS Package. However it is failing when executing the package
I have Fabric Lakehouse as a Source , I am able to connect to the Fabric Lakehouse via Authentication as "ActiveDirectoryPassword" from SSMS without any issue. I am creating the SSIS package and created the ADO.NET connection Manager and…
asked 2024-12-12T22:39:50.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(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
Vineeta Trivedi
0
Reputation points
commented 2024-12-16T01:42:10.08+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, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
5,835
Reputation points Microsoft Vendor
1 answer
SSIS Incremental Extract and Load for Multiple Tables in one Job / Pipeline
Greetings, We have one Source System DB (SQL) which had 120 Tables. I want to Extract all Tables (120) from Source Database and then Load them in Target Database (which is also SQL). Key Requirements: I want to run this as Job, one time daily …
asked 2024-12-12T12:02:51.8133333+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(185.6, 40%, 27%)' 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)
Dinesh Kumar Sharma
20
Reputation points
answered 2024-12-13T05:22:18.33+00:00
ZoeHui-MSFT
39,111
Reputation points
2 answers
User access failure SQL integration
Hi, im having this issue. How can I grant myself the proper access to pass this stage? I tried everything but it still running into same issue. A screenshot of the issue I'm having is below. How can I resolve this
asked 2024-12-11T20:09:16.33+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(156.8, 63%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ3%3C/text%3E%3C/svg%3E)
ZM-3283
40
Reputation points
answered 2024-12-12T07:33:31.6733333+00:00
Olaf Helper
45,376
Reputation points
1 answer
How to Force SSIS in Visual Studio 2022 to use ODBC Version 2.5 Connection
Hi, I have to migrate SQL Server SSIS packages from a legacy machine onto a new one. The legacy machine used - as the IDE - Visual Studio 2017. These packages copied data from an existing 3rd-party system using their ODBC driver as the source…
asked 2024-12-09T14:17:31.2866667+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, 88%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Mr. C
0
Reputation points
commented 2024-12-11T21:43:57.3633333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
ADO.NET connection failure to Azure Database from VS 2022 SSIS Package running against SQL Server 2022 using Microsoft SQLClient Data Provider
I have a SSIS package running on SQL Server 2022 in VS2022 that connects to a 3rd party Azure database as a source with ADO.NET using Microsoft Entra Password that has been running successfully for a few years. However, recently I needed to make…
asked 2024-11-12T13:59:46.06+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, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Teresa Thomas
21
Reputation points
accepted 2024-12-10T13:16:16.3666667+00:00
Teresa Thomas
21
Reputation points
1 answer
SSIS package no running in 64 bit mode.
I have an ssis project that is running perfectly on SQL Server 2019 using x32 bits and i need to run it on x64. I have installed the OLEDB drivers, sql server on x64 both 2019 and 2022 and when i tried to execute it shows this error locally. Also im …
asked 2024-12-08T04:17:32.77+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(307.2, 91%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA8%3C/text%3E%3C/svg%3E)
Alex-8104
0
Reputation points
commented 2024-12-10T05:22:06.9433333+00:00
ZoeHui-MSFT
39,111
Reputation points
2 answers
One of the answers was accepted by the question author.
Parsing a comma delimited file that has comma embedded within double quotes
Hello: I am working with a Integration Project in MS VS 2019. I have a comma-delimited flat file. One of the fields is double-quoted and may have a comma inside it. When the file gets parsed, it gets thrown of by the embedded comma, For example, one of…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,316 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,622 questions
asked 2020-11-25T17:15:54.137+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, 0%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Venkat Venkataramanan
76
Reputation points
commented 2024-12-09T07:50:18.6966667+00:00
Fauxjacket
0
Reputation points
2 answers
Login failed for user domain/machinename$ on SharePoint subscription servers
We have Application and web server in which we have installed Sharepoint server subscription edition. Both the servers shows below SQL error under server logs. ‘Microsoft Monitoring Agent’ which is a health service and tries to connect with SQL system…
asked 2024-12-03T17:44:27.6466667+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(240, 49%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Snehal Sutar
0
Reputation points
commented 2024-12-04T21:48:55.44+00:00
Erland Sommarskog
114.6K
Reputation points MVP
0 answers
While connecting PowerBi Dataset from SSIS through SSAS processing Task
While connecting PowerBi Dataset from SSIS through SSAS processing Task , I could not make test connection successful. However, I could the tables of PBI dataset and while processing it is throwing the error like below "[Analysis Services…
asked 2024-12-02T08:26:30.1966667+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(208, 95%, 30%)' 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)
Prabu, Chandran
41
Reputation points
commented 2024-12-03T07:26:35.6733333+00:00
ZoeHui-MSFT
39,111
Reputation points
1 answer
How to Force SSIS to Extract data from read-only excel
Hi Everyone, I have an SSIS package that loads data from Excel into SQL Server database, currently the package keeps failing with this error: It is already open exclusively by another user or you need permission to view and write its data. None of these…
asked 2024-12-02T17:37:36.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(128, 82%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
tobz
161
Reputation points
answered 2024-12-03T05:27:06.25+00:00
ZoeHui-MSFT
39,111
Reputation points