title: SSIS Flat File Source Text Qualifier being ignored
body: <p>I am using SSIS to insert data from flat file to database.</p>
  
  <p>I have created Data Flow Task for that. I am using Flat File as Source and ADO NET Destination to insert data.</p>
  
  <p>Below is how my setting looks like for Flat File Source.</p>
  
  <p><img src="https://i.stack.imgur.com/SG118.png" alt="Flat File Settings"></p>
  
  <p>Below is how my "Columns" tab look like</p>
  
  <p><img src="https://i.stack.imgur.com/aggGf.png" alt="ColumnsTab"></p>
  
  <p>THIS WORKS FINE WHEN I RUN THAT USING BIDS AND DATA IS INSERTED PROPERLY INTO DATABASE. IT EVEN WORKS WITH DTEXEC.EXE WHEN RUN LOCALLY.</p>
  
  <p>Now, The problem is with executing the package on the server using dtexec.exe. On the server, data is inserted properly but the text qualifier (double quotes) given is totally ignored while inserting data to database. THE SAME WORKS TOTALLY FINE WHEN RUN LOCALLY. I have attached image below for how its stored in database.</p>
  
  <p><img src="https://i.stack.imgur.com/vsSdE.png" alt="Data Inserted into Database"></p>
  
  <p>I have checked SQL SERVER version and SSIS version locally and on remote server and both are same.</p>
  
  <p>What can be the problem? Can anyone help?</p>