340,224 questions

Sort by: Updated
0 answers

Best way to learn SSIS

I got a new role where we will use SSIS to migrate data from test system to production. What would be the best way to learn SSIS as I have worked with T-SQL and SSMS. It will be on premise 2019 edition.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,651 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
491 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,243 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,549 questions
asked 2024-04-19T19:35:40.58+00:00
Jonathan Brotto 0 Reputation points
0 answers

Synapse Spark v3.4 CREATE DATABASE testdb LOCATION '<>' Not working on Spark 3.4

Executing the following statement on Apache Spark runtime 3.4 results in an error. Tried to do this on different vanilla spark pool configurations on different tennants in West Europe. database_name = 'test_sppool34' target_location =…

Azure Synapse Analytics
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.
4,346 questions
asked 2024-04-12T11:58:34.6166667+00:00
Arthur Steijn 21 Reputation points
commented 2024-04-19T19:35:08.53+00:00
BhargavaGunnam-MSFT 25,876 Reputation points Microsoft Employee
0 answers

Is support for SQL data queries in Excel being phased out?

I was told today by my IT department that I'll have to stop using Excel with SQL data queries to pull data directly into Excel from a SQL server. They stated that Microsoft was phasing out this feature. I couldn't find anything searching the Microsoft…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,441 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,651 questions
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.
2,793 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,549 questions
asked 2024-04-19T19:34:52.87+00:00
Colin Sachs 0 Reputation points
1 answer

Error building configuration in an external startup class. Getting the below error while upgrading Function app from 3.x to 4.x . Even though all the packages are upgraded to latest versions asked getting the same error

Microsoft.Azure.WebJobs.Script.ExternalStartupException : Error building configuration in an external startup class. ---> Microsoft.Azure.WebJobs.Script.HostInitializationException : One or more loaded extensions do not meet the minimum requirements.…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,211 questions
asked 2024-03-19T14:11:26.9033333+00:00
VikasRajareddy-9365 26 Reputation points
commented 2024-04-19T19:34:39.1266667+00:00
Ryan Hill 25,476 Reputation points Microsoft Employee
0 answers

Microsoft.Azure.WebJobs.Host: Error indexing method

Hello, I'm working with an AzureFunction(CosmosDBTrigger), everything was working ok but suddenly the function stop working. When I want to Run the function I got the following errors: my host.json: { "version": "2.0", …

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,211 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,346 questions
asked 2023-09-08T17:47:55.2533333+00:00
Roberto Lopez Colin 0 Reputation points
commented 2024-04-19T19:34:34.1733333+00:00
JT Bruch 0 Reputation points
0 answers

bug? Please upvote- Visual Studio 2022 - ATL Add Method not generating stub function in class - fails CoCreateInstance also

Greetings, Update: Bug report link: https://developercommunity.visualstudio.com/t/ATL-support-broken-in-VS2022/10642527 I believe ATL method/property generation is broken in Visual Studio 2022. I can add methods and properties to the interface, but…

C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,519 questions
asked 2024-04-18T20:26:06.75+00:00
Donald T. Hess 0 Reputation points
commented 2024-04-19T19:34:09.5533333+00:00
RLWA32 40,021 Reputation points
1 answer One of the answers was accepted by the question author.

Is it possible to create and set styles and/or template for combobox in c# only?

Hi, I'm trying to setup a app frontend in C# only. I'm more practiced with c# then XAML, but also have the feeling that I can make the app windows/pages more parametric in this way. Thus far I'm succeeding in this, however when I tried setting up…

Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,667 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,204 questions
asked 2024-04-12T14:03:37.46+00:00
Reinder Weenink 20 Reputation points
accepted 2024-04-19T19:33:39.5866667+00:00
Reinder Weenink 20 Reputation points
0 answers

how can I find email address, cn number etc. in Get-CalendarDiagnosticObjects DisplayAttendeesAll names ?

Good Day Friends, I want to take calendar events with attendee list, by that I'm using CalendarDiagnosticObjects in PS, but in DisplayAttendeesAll part it's just showing the names. There are several people in the organization or in meeting request (as…

Microsoft Exchange Online Management
Microsoft Exchange Online Management
Microsoft Exchange Online: A Microsoft email and calendaring hosted service.Management: The act or process of organizing, handling, directing or controlling something.
4,166 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,355 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,037 questions
asked 2024-04-17T07:13:22.0166667+00:00
Guney 20 Reputation points
commented 2024-04-19T19:33:28.55+00:00
Guney 20 Reputation points
0 answers

Azure Data Factory is not firing the trigger when I create a blob as output from ETL tool

Hi, I'm using a ETL tool to save files into a blob container and it is not firing the trigger that I have created to the process. When I manually upload the file to the storage, it works fine. Can someone help?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,486 questions
asked 2024-04-19T14:57:13.3966667+00:00
Azevedo Emanoel 1 Reputation point
commented 2024-04-19T19:32:09.37+00:00
BhargavaGunnam-MSFT 25,876 Reputation points Microsoft Employee
0 answers

SSRS Going Away?

I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,651 questions
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.
2,793 questions
asked 2024-04-19T19:31:42.4666667+00:00
Colin Sachs 0 Reputation points
0 answers

How to remove device from authenticator application

My account was compromised and used through someone else’s authenticator app. They’re still able to access my microsoft account via authenticator app and I need some way to get them off. Changing my information doesn’t do anything.

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
5,448 questions
asked 2024-04-19T19:30:39.26+00:00
୨୧ ‎ 0 Reputation points
1 answer

Azure Functions - Logging not working correctly in local

I have a simple dotnet-isolated Azure function written in .Net 8 which has 1 Http trigger function. I have another custom database logger which is added to this function to enable database logging. When I am executing the function, none of the Microsoft…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,211 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,204 questions
asked 2024-04-17T14:04:02.69+00:00
Singh, Rahul 1 Reputation point
commented 2024-04-19T19:29:24.5733333+00:00
Singh, Rahul 1 Reputation point
0 answers

Does Azure support a .skin domain?

I am a web designer who built a website for a customer that owns a .skin domain name. When connecting the site to the domain, even after 48 hours, a 404 error is received. Our developers isolated the issue to Azure not supporting ".skin"…

Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,829 questions
asked 2024-04-19T19:25:50.91+00:00
Daniel Mcglaughlin 0 Reputation points
edited the question 2024-04-19T19:26:43.6033333+00:00
Daniel Mcglaughlin 0 Reputation points
1 answer One of the answers was accepted by the question author.

Azure speech to text giving WebSocket error in docker

I'm making a website using Next.js 14, and I want to add speech-to-text functionality to it. I followed this sample code as a guide: https://github.com/Azure-Samples/AzureSpeechReactSample. Locally, it's working as expected; the token is being fetched…

Azure AI Speech
Azure AI Speech
An Azure service that integrates speech processing into apps and services.
1,383 questions
asked 2024-04-14T17:13:35.11+00:00
Andris Kokins 30 Reputation points
commented 2024-04-19T19:26:22.9133333+00:00
VasaviLankipalle-MSFT 13,771 Reputation points
0 answers

Issue while adding custom domain to azure front door standard tier

Hi All, Greetings!!! As a part of a POC while trying to add a custom domain to the Azure front door standard tier, I created a certificate in azure key vault with the subject as the intended custom domain ("CN= <custom domain>"). CNAME…

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,102 questions
Azure DNS
Azure DNS
An Azure service that enables hosting Domain Name System (DNS) domains in Azure.
594 questions
Azure Front Door
Azure Front Door
An Azure service that provides a cloud content delivery network with threat protection.
575 questions
asked 2024-04-19T11:23:51.4333333+00:00
Sarathi 0 Reputation points
edited the question 2024-04-19T19:22:59.87+00:00
Sarathi 0 Reputation points
0 answers

.Net 8 dotnet-isolated runtime starup errors for function app

I successfully migrated one of the function apps while another ran into an error and I get the following error on startup while locally it runs fine I have removed the WEBSITE_RUN_FROM_PACKAGE from app settings while it automatically gets created when…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,211 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
920 questions
asked 2024-04-19T16:03:48.2466667+00:00
Muhammad Ammad Khan 0 Reputation points
commented 2024-04-19T19:22:06.3233333+00:00
Ryan Hill 25,476 Reputation points Microsoft Employee
0 answers

Connection to azure cognitive service failed with Firefox

based on Firefox 84, we have a voice-assistant app, it works fine until last Saturday(4.11)。 Azure API from https://learn.microsoft.com/en-us/azure/ai-services/speech-service/how-to-recognize-speech?pivots=programming-language-javascript the api…

Azure AI Speech
Azure AI Speech
An Azure service that integrates speech processing into apps and services.
1,383 questions
asked 2024-04-16T10:14:58.88+00:00
Yan AI 10 Reputation points
commented 2024-04-19T19:21:15.6566667+00:00
VasaviLankipalle-MSFT 13,771 Reputation points
1 answer

Resources missing to complete the exercise?

Hi In module "Petabyte-scale ingestion with Azure Data Factory or Azure Synapse Pipeline" in unit 4, I cannot complete the excersize since credentials to Amazon S3 are needed. Kindly advise, Thank you Tamir

Azure Training
Azure Training
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Training: Instruction to develop new skills.
854 questions
asked 2024-04-13T10:33:31.1166667+00:00
Tamir Basin 0 Reputation points
edited a comment 2024-04-19T19:19:05.68+00:00
SiddeshTN 2,230 Reputation points Microsoft Vendor
0 answers

Error creating App Service Plan - Bad Gateway - The subscription is not allowed to create or update the serverfarm

Getting an error creating the App Service Plan in both my subscriptions. Tried deleting and re-creating multiple times, but the error still persists. Correlation ID: 2a6c3f09-1db8-472d-84b0-a1b6778a2556 { "status": "Failed", …

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,211 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,829 questions
asked 2024-04-19T19:18:05.1166667+00:00
Gautam G 0 Reputation points
1 answer

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,651 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 0 Reputation points
edited an answer 2024-04-19T19:17:32.3866667+00:00
Yitzhak Khabinsky 24,936 Reputation points