title: Using SSIS 2012 package parameters for connection properties
body: <p>I am trying to write ETL that collects data from many identical server into a central repository. What I'm trying to do is write one package with source address, user id and password as parameters and execute the package once per server to be copied.</p>
  
  <p>Is this doable? How can I use parameters to create a source?</p>