Monthly Archives: November 2013

Import dirty csv file

Let’s pretend that you need to import neat.csv file (provided by external vendor/partner/system) to your database table . You must be lucky to import data like this: ==================== Field1,Field2,Field3,Field4 1,”A”,10.0,2013/10/01 2,”B”,20.0,2013/10/02 3,””,0,2013/10/03 ~~~~~~~~~~~~~~~ As you can see, here is 3 records with … Continue reading

Posted in C#, SQL, SSIS | 1 Comment