title: How to execute and save sql parameterized query in ssis?
body: <p>I've driving mad with this...
  I have a parametrized query to extract some information from a data source, but first, I obtain via OLE DB Source those parameters I need to make my query, them I need to do the query and save both the parameters and the result y my fact table.</p>
  
  <p>More explanations, I have projects and dates, my dimensions, I need a metric, my fact, resulting of a query ( i have the query it works in sql server) that has as parameters the project and the date, and returns the metric.
  My ETL idea was like this: Ole DB Source -> Ole DB Command (because it supports parametrized query) -> Ole DB Destination</p>
  
  <p>But them I discover, OLE DB Command does not have and out put, I've been trying other ways but I dont know how, please, help!!!
  Anabel</p>