"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

May 15, 2018

Dynamic SSIS Connection Strings

Two Important Learnings

  • Configure Map parameters as mentioned in below screenshots
  • Enable Delay Validation both at connection and package level
Connection Level Setting

Package Level Parameters and Dynamic Strings Defined

Package Level Setting

Happy Learning!!!
Post a Comment