- Add a new Script Component, to your data flow and set the type to transformation.
- Edit the component and go to the Inputs/Outputs tab. Under the output add a new column. Make sure it has a data type of Guid (FYI, I have seen references the type is called DT_GUID; however, my version of VS is not functioning properly. My data type field is all black and when I click in it, the edit dialog closes. I set the data type by finding the output column in the xml and setting the dataType attribute to "guid".
- Go to the script tab and in the method add Row.<YourColumnName>
=Guid.NewGuid()
A very easy work around.
No comments:
Post a Comment