Hi there. I have a table with an auto increment identity field.
My DTS Transform runs fine until I start adding to the other phases. The
Error that occurs is the Usual integrity violation can't insert null data
which violates constraints.
I'm not sure why this is happening My Enable identity insert is uncheked and
check constraints is checked and the DTS runs fine. However when I set up
some Global variables in the Pre source data phase, prior to any new Insert
success insert failure phasesetc, the DTS fails. How is this? I have tried
checking the insert identity field and unchecking the check constraints
options, but no luck. there is no source identity data, so its puely an
automatic increment in the destination identity field.
I know that there is a way round this but am unsure where it goes? Anu
advice please would be great. Many thanks Tim