title: How to Pass parameter in ADO.NET Source SSIS
body: <p>Hello I need some help This will be my first SSIS package and I am learning as I go. So far this is what I have. </p>
  
  <p>I created a Control Flow. Then I created three ADO.Net connections, twofor source and one for destination. Then I created data flow tasks it copies data from a table in one database into a corresponding table in another database on the same server.  data flow task has an 2 ADO NET Source and ADO NET Destination. The destination simply maps the fields together. </p>
  
  <p>Okay, so far so good. This is my problem. Some of the source queries have date criteria. An example would be:</p>
  
  <pre><code>SELECT --Code Here 
  WHERE CONVERT(varchar, call_date, 112) BETWEEN '6/1/2013' AND  '7/1/2013'
  </code></pre>
  
  <p>I want to replace these hard-coded dates with variables. Something like:</p>
  
  <pre><code>WHERE CONVERT(varchar, call_date, 112) BETWEEN STARTDATE AND ENDATE
  </code></pre>
  
  <p>I've read several posts and tried to do what is being described, but it's not sinking in. So please use my example to tell me how to do this. It would be nice if I could have the package prompt me for the Date when I run it, but I'd be very happy just to learn how to pass a variable into the query.</p>
  
  <p>This is the only solution I know because I just a beginner here in SSIS package I hope someone can help me</p>