August 25, 2008 at 1:12 pm
I have a GUID column on a table that SSIS is populating. The column has a default of NewID(). Is there a way to exclude that destination column. I don't want to ignore it, then it ends up with a null value.
I simply don't want it included as a destination column so it will use the default NewID()
My second approach is to generate the GUID in SSIS but not sure how to do that. Maybe the script component?
any help would be appreciated.
August 25, 2008 at 1:35 pm
You need to not allow NULL or specify to use the default. If your column does not allow NULL, selecting the "Ignore" option will use the default value. Otherwise, using the default value is a bit tricky and will depend on the component used to insert the values.
August 25, 2008 at 2:04 pm
Thanks Michael - I overlooked something earlier that your comments led me back to.
Have a great day.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply