Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,089 questions
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.2K
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,755
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
38,796
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,371
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.2K
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
38,796
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,304 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,616 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.2K
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
38,796
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
38,796
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS requirement at deployment server with Excel files as data source?
Hello, I have a SSIS that was created from Visual Studio 2019. It loads the data from an Excel file to a table in a SQL database. The development computer has Windows 10, M365, and Microsoft Access Database Engine 2016 (both 32 and 64 bits). It runs…
![](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(3.2, 5%, 10%)' 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)
2 answers
SSIS package that supposed to export data from SQL to Excel stopped working after upgrading to SQL2022
Hello. We have multiple SSIS packages that import data from Excel into SQL and export results back to Excel. All those SSIS packages were designed in VS 2012, connecting to SQL 2012 and Excel 2013, and we can run it successfully as a part of SQL job or…
![](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(172.8, 10%, 26%)' 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)
5 answers
Cannot install SSIS, no Visual Instance Studio found
I have Visual Studio 2022, Visual Studio 2017, SSMS 19 installed on my machine, but when I go to install SSIS no instance of VS is found.
asked 2023-07-26T22:35:33.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(310.4, 6%, 40%)' 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)
Krista Moore
35
Reputation points
commented 2024-12-02T19:24:42.1533333+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, 50%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Bukstein, Jay (He/Him/His) (MNIT)
0
Reputation points
2 answers
Corrupted Source Data Issue in SSIS 4.6 with Excel Source via Data Flows in VS 2019
Using SSIS 4.6 on VS 2019, with an Excel (Prof Plus 2016) Data Source, and I have a Package with 6 Data Flows that run consecutively, each one will access a different sheet from the same Excel Workbook. The Destination is a SQL Server 2022. If we use…
asked 2024-11-26T17:40:53.01+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, 49%, 27%)' 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)
Adel Mansour
0
Reputation points
answered 2024-11-29T22:19:21.86+00:00
Adel Mansour
0
Reputation points
3 answers
SSIS High Availability and Disaster Recovery
Greetings, Pls suggest the approach / method to Implement High Availability and Disaster Recovery for SSIS Thanks and Regards Dinesh Sharma
asked 2024-11-28T08:27:21.9866667+00:00
Dinesh Kumar Sharma
20
Reputation points
answered 2024-11-29T06:53:12.47+00:00
ZoeHui-MSFT
38,796
Reputation points
1 answer
How to fix SQL Server 19 issues with Act Premium Cloud version
I am trying to load SQL Server 19, required to use with ACT Premium for Cloud, so I can use word processing, email and other items such as Act database templates, mail merge, etc. ACT onboarding tells me the SQL Server integration is a Microsoft issue,…
asked 2024-11-27T15:25:56.7466667+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, 49%, 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)
shep greene
0
Reputation points
answered 2024-11-28T21:52:28.46+00:00
Erland Sommarskog
114.2K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
SSIS Server Infrastructure (CPU, Memory) Estimate
Greetings, We are planning to implement SSIS (For ETL) and SQL DWH (For processing and storage). We have will have around 200 tables to extract incremental data. ETL Activities will be small, mostly COPY Activities. Source system has total 200 tables,…
asked 2024-11-18T13:18:15.1533333+00:00
Dinesh Kumar Sharma
20
Reputation points
accepted 2024-11-28T08:37:15.1066667+00:00
Dinesh Kumar Sharma
20
Reputation points