Steve is there any way to create the linked service as a dynamic. Like I need to load the data from one server to multiple server in that case my source is static but sink should be dynamic. How can I do that? Is it possible?. I will have multiple datasets and I need to sink dataset as a dynamic in the copy data activity.