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:
Then set the type of the column to unique identifier (DT_GUID). That’s it.