Sql Server DTS Error Problem
If you get an error similar to this "cannot insert the value null into column" X "table" Y "column does not allow nulls" "insert fails" ive notices 2 common problems. This is common in sql server when importing data into your database.
1. Do not map or associate data in any way to any identity column. skip it.
2. On your transformation, go to the options and uncheck "Enable Identity Insert".