title: What variable type use to represent a Money in SSIS
body: <p>I need to load a Money value in a variable in SSIS using a "Execute SQL Task" component.
  I map the return column of a SELECT to a variable.
  I've declared the variable "UnknownMoney" as a Double or a Single, but i always receive the error:</p>
  
  <pre><code>Error: 0xC002F309 at Load Dummy vars, Execute SQL Task: An error occurred while assigning a value to variable "UnknownMoney": "The type of the value being assigned to variable "User::UnknownMoney" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.".
  </code></pre>
  
  <p>The Money column type in SSIS is DT_CY (Currency) but this type is not available for variables. </p>
  
  <p>What's the right type to be used for a Money?</p>
  
  <p>EDIT: the variable type drop down listbox in VS2012:</p>
  
  <p><a href="https://i.stack.imgur.com/Tv7sx.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Tv7sx.jpg" alt="variable type listbox 2"></a>
  <a href="https://i.stack.imgur.com/xdCJa.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xdCJa.jpg" alt="variable type listbox 1"></a></p>