title: SSIS Connection String
body: <p>I have a local SQL DB and an Azure SQL DB. In my data flow I am trying to pass data from local (ole db source) to Azure (ole db destination).</p>
  
  <p>I am unable to save the password for the connection string so I have parameterized the connection string of the data flow task but I seem unable to work out how to get the destination to use it?</p>
  
  <p>I know this isn't best practice but I just want to prototype a few things. Is this possible?</p>
  
  <p>Thanks</p>