title: Exchange Rate Return
body: <p>I am building a Monthly License Report for our IT department and it receives a list of License information in Euro's. I have an XML feed that provides Exchange rate data daily but the job will only be set to run once a month. </p>
  
  <p>I have a conditional split set up in my SSIS package that splits off the USD exchange rate and discards everything else. </p>
  
  <p>What I have left to do is to return only the exchange rate for the 1st of every month, I don't need every day just the day the report runs.</p>
  
  <p>Is there an SSIS expression that will return only that line out of the XML feed?
  Or is there an SQL-T Script that will return only the first month data?</p>
  
  <p>Date format is MM/DD/YYYY, I have a sequence of Derived columns that creates a [DateKey] for my [DIMDate] that is formatted as YYYYMMDD.  </p>