Flat file processing

• anil.padharthi

  Newbie

  Points: 3

  More actions

  May 19, 2011 at 5:49 am

  #150231

  I am having a flat file with some 20000 rows, while loading the data after 10006 records it found an excetion and the loading fails. my questions are

  1.what will happen to the data(first 10006 records) loaded previously. will it be saved in database or it will get rollback?

  2. if it gets rollback means(after fixing the exception),again if i load the data means again it will take time to load the data how to overcome that.

  3.Is there any other proces to save the records loaded to database utill exception. will checkpoint will do that

• vineet_dubey1975

  SSCrazy

  Points: 2306

  More actions

  May 27, 2011 at 5:58 am

  #1330913

  You can follow :

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65473/