Importing from Excel - 10-05-2007 , 11:42 AM
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.
RE: Importing from Excel - 10-11-2007 , 07:45 AM
Question for you: Are you supplying the GUID in the SSIS package or relying
on a Field default in the destination table to supply the GUID?
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]