ADF data Flow SQL Server as Sink

jmarciogsousa 6

Hi I have one issue with the sql server database with the table as parameter on the data set:

On the DataFlow the parameter not appear as option but of course gives a message that the parameter is not provided:

1 answer

HarithaMaddi-MSFT 10,136 Reputation points

2020-09-10T15:10:39.55+00:00

Hi @jmarciogsousa ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

The dataset parameters need to be defined for table schema and name for which values can be passed from dataflow activity of pipeline. I have passed pipeline parameters as table schema and name values for SQL DB which is used as Sink. Please find below snap and GIF with the details.

Please let us know if this is not aligning with the requirement or for further queries and we will be glad to assist.
Please sign in to rate this answer.
HarithaMaddi-MSFT 10,136 Reputation points

2020-09-11T09:11:37.773+00:00

Hi @jmarciogsousa ,

We did not receive response from you. Following up to check if the above answer helped you. Please let us know for further queries and we will be glad to assist.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

HarithaMaddi-MSFT 10,136 Reputation points

2020-09-14T07:49:54.267+00:00

Hi @jmarciogsousa ,

We still have not heard back from you. Please let us know for further queries and we will be glad to assist.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer