Getting an error when using the Flexible File Destination Task in Visual Studio 2022 SSIS
I am trying to setup a data flow task in Visual Studio 2022 using the Flexible File Destination. This task is used in an SSIS pipeline to copy data to an Azure blob or Data lake. I have setup the Azure connection and the Test connection succeeds. I am using an access key to authenticate to the azure storage container.
The error I get when I run the flow is : Error: 0x0 at Data Flow Task, Flexible File Destination: Transfer data error : System.ArgumentException: The required property is not specified. Parameter name: msiAuthenticator
Is there something else I need to configure here? I see nowhere else where I need to put in a property called msiAuthenticator.
I have tried connecting with SAS as well as service principal but get the same error. I have installed the latest SSIS extension for Visual Studio 2022. I am able to open the storage container successfully in Azure Portal as well as Azure Storage explorer.
Thanks! Screenshots of ssis:
I managed to solve this issue by setting the ProtectionLevel of my project and its packages to EncryptSensitiveWithPassword. It was previously set to DoNotSaveSensitive.
- Invalid operands found for operator -eq
- Adding custom headers to Azure Functions response
- Azure Queue Trigger is hit but not executing the logic inside of it
- az cli not showing redisenterprise keys
- Enforce MFA for specific API called from SPFx via AADTokenProvider (Even with SPO MFA)
- Azure Devops Server Pipelines: Any way to have a Stage result as "Succeeded" even if a constituent Job reported "SucceededWithIssues"?
- YAML strings including special characters % and & were not printed correctly for Windows environment
- Azure function returns error: No job functions found. Try making your job classes and methods public
- How to view Oldest Query results in Azure Monitor Metrics for an Azure PostgreSQL Flex Server instance
- Authenticate to Azure with certificate from Linux
- What are the minimum Azure permissions required to publish a Power BI report using "App Owns the Data"?
- Refresh an Azure search index
- Best way to clean up resources in StatefulService
- Azure Function App - No continuous deployment setting for "Flex Consumption" hosting plan?
- Query Azure SQL Database using Rest-API
- How to create a feature burndown chart in Azure DevOps?
- Why is this "call is ambiguous between the following methods or properties" when calling ValidateOnStart?
- How to write a Bicep API Connection formrecognizer with api key
- Where can I find docker container logs for Azure App Service
- will looping GetBlobsAsync() but doing nothing in the loop body read the contents of the blob
- Connect to OneDrive using Python (msal) and client secret
- How to debug ServiceBus-triggered Azure Function locally?
- Does Azure Cognitive Services support (detect and compare) Handwritten Signatures and Stamps from two images?
- Modify ARM-Template for quick deployment
- Does anyone have implemented auxiliary logs deployment in sentinel?
- Get request headers in azure functions NodeJs Http Trigger
- Filter specific items that are alone in an array of Collection String in Azure Search
- Trouble obtaining access token for managed identity with application role
- Azure Autoscaling Duration Time and Cool Down Time
- Partition Key for Cosmos DB