i am trying to import into mssql db a text delimited file. When it reaches the last row I get error "cannot insert the value NULL into column 'CustomerID', table "table"; column does not allow nulls." I have removed all white spaces in the text file. And Ive made CustomerID an autonumber seed 2 increment 1. Im at the end of my rope. also I have mapped the fields in transform appropriately I believe. Thanks in advanced.