Hot answers tagged

3

Files checked with hex editor and answer revealed. My CSVs differed in that rows either terminated with: Hex 0D CARRIAGE RETURN (\r), or Hex 0D CARRIAGE RETURN (\r) AND 0A LINE FEED (\n) This is a very important line of code: LINES TERMINATED BY '\r\n' or LINES TERMINATED BY '\r' In my case, taking out the \n took care of it - either CSV ...


1

The Import/Export wizard builds an SSIS package under the covers but the package the wizard builds only performs the E and L of ETL (Extract, Transform, Load). What you're looking for is T because you needed to transform this weird data into something more manageable. For the weird header row, you can always specify that there is no header row and the ...



Only top voted, non community-wiki answers of a minimum length are eligible