text file to SQL table with identity column failing

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  April 22, 2008 at 11:10 am

  #121822

  Hi,

  I am using data flow task to load data with the source as text file to sql server table with identity column. After mapping all the column except identity column, when I execute, the package failing saying it can not insert null value into identity column. I donno how to get around with it ????

  Thnaks,

  V

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  April 22, 2008 at 12:08 pm

  #805673

  soved it anyway..I unchecked keep the identity column checkbox...