Any One help for this... I am also getting the same problem.I am not
understanding this.If i insert record making the ID column as allownulls(not
primary key,Identity) its doing without any errors.If I make it as Primary
key,then it is printing same error.Why???? Any One help Plzzz.... urgent..

url:http://www.ureader.com/msg/1146110.aspx

hi, don't know if it's too late. I was having the same problem and came
across your post.
what I did is in transformations ->edit->destination column, unselect the
identity column, then in "options" tab, unselect "enable identity insertion",
that worked

url:http://www.ureader.com/msg/1146110.aspx