title: BCP not working when {CR} is missing & {LF} is present at the end of a fixed length file
body: <pre><code>SET @query='bcp Staging.DBO.MSP_Tin_Reference_Response_FileImport in '+@TinResponseFilePath+@TinResponseFileName+' -T -c ' 
  EXEC MASTER..xp_cmdshell @query --,1
  </code></pre>
  
  <p>And it throws following error:</p>
  
  <pre><code>NULL
  Starting copy...
  SQLState = S1000, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in BCP data-file
  NULL
  0 rows copied.
  Network packet size (bytes): 4096
  Clock Time (ms.) Total     : 1     
  NULL
  </code></pre>
  
  <p>I appreciate any help you could give me.</p>