question

arkiboys avatar image
0 Votes"
arkiboys asked NandanHegde-7720 answered

dynamic servername to sql server connection

Hello,
I have hard coded the linked service to the sql server
When I click on the 'add dynamic content' link under the server name box, I only see a blank window as below.
How can I make this server name dynamic ?
Note that in the data factory pipeline, I do have a parameter pSourceServer which is read from the database table.
Thank you

130795-image.png


azure-data-factory
image.png (72 B)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered

Hey,
You can refer the below link:
https://docs.microsoft.com/en-us/azure/data-factory/parameterize-linked-services?tabs=data-factory
for parameterising the Linked service in ADF

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.