SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,664 questions
2 answers
One of the answers was accepted by the question author.
MSOLEDB connection manager
I am using SSIS 2019 to create packages. In the list of connection manager driver, I cannot find MSOLEDBSQL, There is a microsoft OLEDB for SQL server, but that is SQLOLEDB, as the microsoft online doc says both SQLOLEDB and SQLNCLI native client…
![](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(147.20000000000002, 18%, 24%)' 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)
1 answer
Data Factory Copy activity failing with Error code 2200 - Operation failed as split count exceeding upper bound of 1000000
Hi , I am copying large data from ADLS gen 1 to ASDW(Azure synapse Analytics) using Data Factory (polybase set to yes and mentioned blob storage settings). The Source data is *.parquet format and is partitioned. Copy activity fails. In first attempt…
asked 2020-10-25T13:53:15.673+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(115.19999999999999, 93%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
kranthi k senapathi
106
Reputation points
commented 2020-10-29T17:45:16.183+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, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
3 answers
One of the answers was accepted by the question author.
Can't access blob from Azure Windows VM
Strangely, we have an issue where we can't download a blob from an azure windows VM but it works perfectly from anywhere else on the internet. I see this: <Error> <Code>AuthorizationFailure</Code> <Message>This request is…
asked 2020-10-21T22:21:00.547+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, 71%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Greg Pringle
31
Reputation points
accepted 2020-10-29T17:39:22.75+00:00
Greg Pringle
31
Reputation points
2 answers
Use Power Automate to connect Excel Online to Salesforce
Hi, we have a task list on Excel in our shared drive and when someone completes a task for a specific client they put their initials in the box for that task. So as an example a row would be the clients name and then 5 or so cells each for a specific…
asked 2020-10-29T17:02:53.31+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(243.2, 40%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jeremy Merrill
1
Reputation point
commented 2020-10-29T17:37:45.293+00:00
Leon Laude
85,976
Reputation points
1 answer
One of the answers was accepted by the question author.
How to use "Open folder" tasks to run custom mingw build / cmake script?
Hello, I just started looking into Visual Studio, since there will be C++20 support soon and my current IDE (Eclipse) seems to have no plans to update anytime soon .. even some C++17 features are still broken. I have a few related questions so I'll use…
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,880 questions
![](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(16, 10%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
API scopes and roles
Hi, When I register an application (Web api) and Expose the API (adding scopes). I see that we can add appRoles in the manifest. Is there a way to associate roles and scopes? Like to say an Admin role has Read and Write scopes and the Employee…
![](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(195.2, 84%, 28%)' 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)
0 answers
Inserting different calendar months onto different worksheets in the same workbook?
Instead of having different Excel files for each of the different months of my calendar, I wanted to have them all enclosed in one worksheet, a different month for each tab at the bottom ("January 2020" on one tab, then "February" on…
asked 2020-10-27T14:09:30.167+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, 82%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Administrative Assistant
1
Reputation point
commented 2020-10-29T17:20:51.417+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(256, 18%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shiva Keshav Varma
421
Reputation points
1 answer
One of the answers was accepted by the question author.
App Registration and MS Graph API User.Read
Hi, When I register an application (web api) and when I go to the API Permissions section. I see that the MS Graph API User.Read is there by default. Is this necessary If I don't plan to access the Graph API? If it is necessary, what would be the…
1 answer
Azure Update Management fails for servers behind Log Analytics Gateway
Hello, Since a few days we can't use Update Management anymore on our on-premise servers that they are using a Log analytic Gateway to connect to Azure. The Update Agent readiness shows "Disconnected" for those servers and any update…
asked 2020-10-26T15:05:42.39+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, 13%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jean-Michel Jacques
1
Reputation point
answered 2020-10-29T17:02:28.273+00:00
tbgangav-MSFT
10,431
Reputation points
1 answer
Azure AD - Custom Claims for onpremise application authentication.
HI Guys I trying to figureout how I can create the right claim ransformation to send to my onpremise application the value he expected. into the source attribute I choosed User.onpremisesamaccountname but my application expect domain\samaccoutname. …
asked 2020-10-29T11:30:31.113+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(73.60000000000001, 13%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mergirie, Emmanuel
1
Reputation point
answered 2020-10-29T17:02:25.917+00:00
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA
27,496
Reputation points
1 answer
One of the answers was accepted by the question author.
APIs to monitor pipleine?
Hi, Are there any APIs to monitory Pipeline, Dataflow, Activities in Azure Data Factory? The API can directly be used in .Net application.
asked 2020-10-26T12:21:49.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(156.8, 61%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Abhishek Vyas
101
Reputation points
commented 2020-10-29T17:02:10.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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,236
Reputation points
1 answer
One of the answers was accepted by the question author.
How can I check if my parameter consists of one or more attributes?
Hi see attachment When the string of the incoming pipeline parameter contains one attribute I should use byName, otherwise byNames. That that would presume I should build two different flows, which for the rest do the same. How can…
asked 2020-10-26T11:52:26.533+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, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Poel van der, RE (Ron)
451
Reputation points
commented 2020-10-29T16:59:41.217+00:00
MartinJaffer-MSFT
26,236
Reputation points
1 answer
Get-AzureADUser : ProvisioningErrors how to export to “normal readable format
Hi, I know, that I can generate export of provisioning errors with command… $errors = (Get-MsolUser -UserPrincipalName "*****@Xdomain.com").Errors $errors | foreach-object {"`nService: "+…
asked 2020-10-29T14:59:44.883+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, 62%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mali Stane
91
Reputation points
answered 2020-10-29T16:56:07.997+00:00
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA
27,496
Reputation points
2 answers
Microsoft.ReportingServices.ReportViewerControl.WebForms version 150.1404.0
After installing Microsoft.ReportingServices.ReportViewerControl.WebForms version 150.1404.0 via nuget in Visual Studio 16.7.7 when I now run an existing rldc in ProcessingMode.Local I get an error: <Error> <Message>An error has…
asked 2020-10-28T23:40:15.44+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(6.4, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Dave Anderson
6
Reputation points
answered 2020-10-29T16:43:43.793+00:00
Dave Anderson
6
Reputation points
0 answers
B2C - Cannot log out when using the Edge browser
During implementtion of the B2C logout process I used the Chrome browser and it was pretty much trouble free - I used the logout endpoint url as specified in the app registrations section in AAD B2C and added the post_logout_redirect_uri to the end of…
asked 2020-10-14T13:41:14.333+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(262.40000000000003, 62%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Neil B
21
Reputation points
commented 2020-10-29T16:38:59.673+00:00
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA
27,496
Reputation points
2 answers
Format for GPS geopoint
I'm sure this should be really simple to find but i can't see this info anywhere. What is the required format for the location property on Iot Central? I can see it is geopoint but i have formatted my data as per the below and this doesn't work: …
asked 2020-10-28T16:01:43.26+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(275.2, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Joshua Bailey
201
Reputation points
commented 2020-10-29T16:38:40.707+00:00
rbrundritt
19,831
Reputation points Microsoft Employee
0 answers
Not able to execute AZ comments using System.Management.Automation lib in IIS
i wanted to execute the az login using System.Management.Automation. its working in my local. when i tried to deploy the same in web server, the system is not recognizing AZ comments, Note: I've already installed AZ cmdlets public class ValuesController…
asked 2020-10-27T15:37:53.013+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(83.2, 47%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Thavaselvan P
1
Reputation point
commented 2020-10-29T16:38:01.373+00:00
JamesTran-MSFT
36,821
Reputation points Microsoft Employee
0 answers
Azure Identity Protection
How Microsoft interprets the Password Spray Attack. After checking the alert what all relevant information we should check if there is a successful compromise of account. There is no sufficient evidence from Microsoft about the Password spray Attack
asked 2020-10-26T12:26:05.153+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(300.8, 7.000000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tony Ambalamvila
1
Reputation point
commented 2020-10-29T16:20:35.387+00:00
JamesTran-MSFT
36,821
Reputation points Microsoft Employee
0 answers
AD B2C ROPC JavaScript Token Retrieval
I have Azure AD B2C and a Blazor Server-side app with a Login page. I created a ROPC Custom Policy and tested with Postman and it retrieves the token with the claims correctly. But when I want to retrieve the token from the browser with JavaScript to the…
asked 2020-10-27T11:33:23.157+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, 85%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Guillem Soler Suetta
1
Reputation point
commented 2020-10-29T16:18:55.253+00:00
JamesTran-MSFT
36,821
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to get data for missing months
Hi, Below is my DDL CREATE TABLE #Temp ( Id INT, ReportMonth int, ReportQuarter int, PaymentAmount MONEY ) INSERT INTO #Temp VALUES (123,1,1,25), (123,3,1,50),(123,4,2,50),(123,5,2,50),(135,1,1,50),(135,4,2,50) …
asked 2020-10-28T18:34:34.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(25.6, 1%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
sujith kumar matharasi
351
Reputation points
commented 2020-10-29T16:11:28.867+00:00
sujith kumar matharasi
351
Reputation points