 <p><em>I will try to put it simple, assuming you are familiar with SSIS and Script Components</em></p> <p>Main problem is that your column contains leading 0's that makes it harder to parse the value to float.</p> <p><strong>Solution 1</strong></p> <p>You will first need to get rid of the leading 0's using a Derived Column component with fitting expression (could be complex)</p> <p>Then pass that column through a data conversion component and set the data type to float</p> <p><strong>Solution 2</strong></p> <p>Pass original column through a script transform component, remove leading 0's and parse it to a new float column in the ProcessInputRow method using .NET</p> <p><strong>C# Example:</strong></p> <pre><code>Row.new_column = float.Parse(Row.Quantite.TrimStart('0')); </code></pre>