dynamic configuration ssdt

Question

HI,
i need to know if w can change provider and server name without opening and manually changing in package. i have server name in parameter but not provider (sql client 11.1)

i want to change this in 100 package , without opening it , or doing it as change parameter in sql server agent job.
is it possible ?

please let me know.

thanks

Answer 1

Hi coool sweet,

1.Please add expression and choose the property that you need in the properties of connection manager.

2.Then drag the parameter in the Expression of Property.

3.After deploying these packages, we can change the value of parameter to change the value of the property when executing ssis package in catalog.

Please refer to Parameterizing Database Connection in SQL Server Integration Services.

Best Regards,
Mona

---

If the response is helpful, please click "Accept Answer" and upvote it.

Answer 2

yes my package is using package level connection that has server name as a parameter.

now i have 200 package which all has server name as a parameter.

but i dont want to go and change in each package.

do we have any script that we can run in SSMS and it update parameter all package at once.

Answer 3

the prob is i have 200 packages to change . is there any way i can change it once?

Answer 4

Usually, SSIS project is using a project level connection. That connection is re-used by all the SSIS packages in the project. If there is a need for a change that's the spot to go.