title: Slowly Changing Dimension Wizard Historical Attribute Options No Start Date to choose from
body: <p>I'm in the historical attribute options tab of the slowly changing dimension wizard. I have the "use start and end dates to identify current and expired records," however when I click the drop down for both start and end date column, end date is my only option for both. How could this be? The start and end dates are the same data types in my dimension table datetime2(7) </p>
  
  <p>I've looked at the dimension table data types to make sure there wasn't a data type issue that could potentially prevent SSIS from recognizing it as a usable field, but start and end date is the same exact data type. So I'm at a loss as to why end date is the only option to choose from. </p>
  
  <p>My expected result is to be able to select the start date in my dimension table for my start date column.</p>