Creating GUID Derived Column in DTS

If you want to add a constant GUID to a table during a DTS transformation, it’s a little tricky.  Here’s the solution.

Use the Derived Column transformation in order to add a new column.  For the formula, use the GUID surrounded by double quotes.  The trick is that you MUST include the curly braces, like so:

"{B83030CF-EC5A-45ca-BE2D-BCFCC2A85034}"

Then set the type of the column to unique identifier (DT_GUID).  That’s it.