I have 10 folders from that i have given filter activity condition to extract a folder name ‘Series’. Inside that folder again i have different folders and again i have given filter activity condition to extract a folder name ‘Schedule’. again inside that folder i have 5 different folders and inside those 5 different folders, i have multiple files and from those files i need to extract only files which are ending with ‘2023102..
Tag : azure
Lets say i have a 5 different folders and inside each folder i have 10 files. Now i have to extract only single files from each folder and those files need to use as a source (ADLS Gen2) for copy data activity and load into Target (SQL Table). This i need to acheive by using Filter activity condition. So how can i write that condition for multiple files inside multiple f..
I have a source file in ADLS Gen2 and target as sql db. But when im going to copy the data into SQL table, the below error it is giving
Failure happened on ‘Sink’ side. ErrorCode=SqlOperationFailed,’Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,”Type=System.InvalidOperationException,Message=The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.,Source=System.Data,”Type=System.InvalidOperationException,Message=String or binary data would be truncated.,Source=System…
We have a need in my company tenant to convert some already existing apps o multi-tenant In Azure/Entra ID. Most of these enterprise apps have SSO setup and wo..
Using Microsoft Azure, how do you audit all launched applications for a given user session? For example, if I am a logged in user with an active session, and I browse to https://www.microsoft365.com/apps, and launch an app from that portal, where is this recorded? I have tried the following ..
I have a question from my Microsoft Practice Exam that I got while purchasing my exam date. Here is the question and a..
When trying to renew the domain for my application, I go h..
How can I generate an entity–relationship (ER) diagram of a SQL data warehouse(dedicated SQL pool) database using ..
I am trying to configure a serverless sql db in azure, which I will use for development.
So far I’ve created a db instance, but have not connected to it, and have no code calling it.
The only thing I have done is use my local SSMS to connect for a few minutes for me to create a test table (id int(pk), test name varchar(50)), and insert two re..
I’m trying to move two Azure SQL VMs that were previously in their own, separate RGs into the same one to make creating a Load Balancer easier. I moved the resources from the first server just fine, but when I try to move the resources from the second server, I get a validation error. It seems to think the TempDB disks are duplicates, and throws an ..