title: SSIS - specify only one parameter in OLE DB Source with multiple '?'
body: <p>when writing my SQL command I specify <code>?</code> to indicate that I want to use a passed in Parameter. However, for every <code>?</code> I use, the package thinks it's a new parameter even though I want to use the same one. </p>
  
  <p><a href="https://i.stack.imgur.com/GhvFU.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GhvFU.jpg" alt="enter image description here"></a></p>
  
  <p>6 <code>?</code> = 6 new parameters though each parameter is the same. As seen on parameter 0 and 1</p>
  
  <p>Is there a way that I can specify just one parameter?</p>
  
  <p>Thanks</p>