Wednesday, August 19, 2020

SSIS Deployments-Package Configurations

 

Click Project->Convert to Project Deployment Model

Then Click on SSIS->Package Configurations

Click Enable package configurations->Add->

Save this configuration with some name.

Can Add connection managers([Source, Destination]). Instead of checking everything, we can set specific fields as well.

config file will look like below. Properties can be changed accordingly.

No comments:

Post a Comment

GEN AI

  Stay Tuned....