title: Problem in importing CSV file with column containig NULL values or comma
body: <p>I have a CSV file with the two columns : </p>
  
  <pre><code>Employee_Name,EmpID
  "Harry, Watson",1
  "Amy, Black",2
  "O'hare, Lynn",3
  Jeremy Prater,4
  ,,
  ,,
  </code></pre>
  
  <p>I am using biml to generate my package : </p>
  
  <pre><code>&lt;Biml xmlns="http://schemas.varigence.com/biml.xsd"&gt;
  &lt;FileFormats&gt;
          &lt;FlatFileFormat Name="FlatFile" CodePage="1252" TextQualifer="&amp;quot;"
          ColumnNamesInFirstDataRow="true" IsUnicode="false"&gt;            
              &lt;Columns&gt;
                  &lt;Column Name="Employee_Name" DataType="AnsiString"  Length="255" Delimiter="Comma" /&gt;
                  &lt;Column Name="EmpID" DataType="Int64" Delimiter="Comma" /&gt;
  
  
              &lt;/Columns&gt;
          &lt;/FlatFileFormat&gt;
  &lt;/FileFormats&gt;
  
  &lt;Connections&gt;
      &lt;FlatFileConnection Name="importexcel"
          FilePath="HR.csv"
          FileFormat="FlatFile" /&gt;
      &lt;Connection Name="AppSTG" 
          ConnectionString="XXXX"&gt;&lt;/Connection&gt;
  &lt;/Connections&gt;
  
  
  &lt;Databases&gt;
  
      &lt;Database Name="STG_App" ConnectionName="AppSTG"&gt;&lt;/Database&gt;
  
  &lt;/Databases&gt;
  
  
  &lt;Schemas&gt;
      &lt;Schema Name="HR" DatabaseName="STG_App"&gt;&lt;/Schema&gt;
  &lt;/Schemas&gt;    
  
  &lt;Tables&gt;
      &lt;Table Name="Employee" SchemaName="STG_App.HR"&gt;
              &lt;Columns&gt;
                 &lt;Column Name="Employee_Name" DataType="AnsiString" Length="255" /&gt;
                  &lt;Column Name="EmpID" DataType="Int64"  /&gt;
          &lt;/Columns&gt;
          &lt;/Table&gt;
  
  &lt;/Tables&gt;    
  &lt;Packages&gt;
          &lt;Package Name="Load Flat File Data" &gt;
              &lt;Tasks&gt;
                  &lt;Dataflow Name="Load Flat File Data"&gt;
                      &lt;Transformations&gt;
                          &lt;FlatFileSource ConnectionName="importexcel" Name="FlatFile"/&gt;
                          &lt;OleDbDestination Name="Target" ConnectionName="AppSTG"&gt;
                              &lt;TableOutput TableName="STG_App.HR.Employee" /&gt;
                          &lt;/OleDbDestination&gt;
                      &lt;/Transformations&gt;
                  &lt;/Dataflow&gt;
              &lt;/Tasks&gt;
          &lt;/Package&gt;
      &lt;/Packages&gt;
  
  
  
  
  &lt;/Biml&gt;
  </code></pre>
  
  <p>To create the following data flow : </p>
  
  <p><a href="https://i.stack.imgur.com/nuFGr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nuFGr.png" alt="enter image description here"></a></p>
  
  <p>When I try to execute the package, I have the following error : </p>
  
  <blockquote>
    <p>« Data conversion failed. The data conversion for column "EmpID"
    returned status value 2 and status text "The value could not be
    converted because of a potential loss of data.".  »</p>
  </blockquote>