title: Stubborn column data type in SSIS flat flat file connection manager won't change. :(
body: <p>I have inherited an existing SSIS package that imports flat file data into my SQL Server 2005 database. I need to change the data type of the "Gross Sales" column from "numeric" to "currency". When I change the data type and export the package the data type remains numeric. </p>
  
  <p>I have also tried creating a new flat file connection to use in the same package, but for some strange reason it still remains numeric instead of "cy" currency. I guess there is something "stuck" in some other area that is forcing the last column to remain numeric?</p>
  
  <p>Does anyone know the trick to changing the data type for a flat file data source?</p>