How do I pass in a parameter to the error logging linked service in a data flow? Here is my parameterized linked service: In my data flow sink I am trying to write skipped rows to blob storage: When I click on Debug Settings in the data flow editor I am prompted to provide a value for the linked service parameter. When I call the data flow via the pipeline canvas I am not prompted to specify a value for the linked service parameter. When the data flow executes it uses the default value, which is incorrect. How can I specify the parameter value I want to pass into the linked service?

How to pass linked service parameter to Data Flow sink for error logging?

Jenkins, Ben 0

How do I pass in a parameter to the error logging linked service in a data flow?

Here is my parameterized linked service:

User's image

In my data flow sink I am trying to write skipped rows to blob storage:

User's image

When I click on Debug Settings in the data flow editor I am prompted to provide a value for the linked service parameter.

User's image

When I call the data flow via the pipeline canvas I am not prompted to specify a value for the linked service parameter. When the data flow executes it uses the default value, which is incorrect. How can I specify the parameter value I want to pass into the linked service?

User's image

Bhargava-MSFT 31,116 Reputation points Microsoft Employee

2024-07-25T21:02:03.25+00:00
Hello Jenkins, Ben,

A similar ask has been discussed with a detailed steps on this below stack overflow post.

https://stackoverflow.com/questions/68089313/how-to-pass-linked-services-parameters-to-data-flow-from-pipeline

Steps:

Create a parameter in the linked service

Create a parameter in the dataset and pass it's value to the parameter in the linked service

create a parameter in your pipeline and set the default value.

Pass the value from pipeline's parameter to your dataset in the setting of Data Flow.

I hope this answers your question. Please let me know if you have any further questions.
Jenkins, Ben 0 Reputation points

2024-07-26T20:57:22.1233333+00:00

Hello @Bhargava-MSFT ,

I don't see an option for this.

My sink is an Azure SQL Database table

The assert failure rows are going to blob storage

When I pass in values when calling the data flow I don't have an option to specify the BlobEndpointURL parameter for the AzureBlobStorage linked service. (The collapsed parameters section is for the source).

Share via

How to pass linked service parameter to Data Flow sink for error logging?

Your answer