Hello,
We just recentely upgraded to SQL 2005 and I'm having trouble with the
Import/Export wizard failing to insert data into my guid columns. A new guid
is supposed to be inserted when a new record is created, but this insn't
happening in 2005. In 2000, I would ignore the guid column in the column
mappings and when the wizard would run, new guid values would be inserted
automatically. This doesn't seem to be happening in 2005 and I get errors
regarding the guid column and the package fails. Can anyone please tell me
how I can fix this? All suggestions would be greatly appreciated.