DTS Error

[ascheper]

Every time I try to insert data through DTS, I get an error for the last row stating:

"Error at destination for row 12...Cannot insert the value NULL into column 'CallID", table "NEWTESTSQL.dbo.CallList"; column does not allow NULLS."

If I change the file to an excel file, it says that the import was successful, but no data appears in the table. I am using the DTS wizard when I do this. Any help or information would be greatly appreciated.

Drew

 

[jhall156]

I know it's an obvious question but is the CallID blank in that last row? I started out with nothing, and I still have most of it.

 

[ascheper]

CallID is blank in every row, I think it may work if I append a row delimiter to the last row...trying shortly

Drew

 

[pmanivas]

Blank and null are two different things, I suppose