Adding a DT_GUID type via Derived Column Transform -
12-15-2006
, 07:19 AM
I have already worked around this one so it is not so critical but though I
would throw it out there anyway:
I tried to add a DT_GUID type column in an error flow using a Derived Column
Transform. (The reason is not important). I copy the value out of a table and
paste it in a format enclosed in double quotes:
"142a89f9-601f-4d75-8980-2a0605de2b16"
and assign it the DT_GUID data type. All looks good but the Derived Col
Transform bombs out during execution. It doesn't like the value I put in.
The question is this: How do I assign a value to a DT_GUID data type so that
is can be used as a GUID in the data flow?
Thanks in advance.
--
Todd Chittenden |