Friday, October 07, 2005

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".