NewId in GUID type of field using Dataflow

[ReportDr00]

How is it possible to use newid() function in dataflow destination to create new id in GUID type field. I can write SQL update or insert statement and use Execute SQL task but i would like to do this in data flow task

here is what i am trying to accomplish

i have a table with 2000 rows and all are unique rows and i would like to create new column that is GUID type and try to insert newid for each row and i will make this as primary key of the table. how could i do this easily?

 

[RiverGuy]

how could i do this easily?

The easiest solution would be to add a UNIQUEIENTIFIER column to your SQL table, and set the default value to NEWID(). That way, you don't need to generate anything from within SSIS. Just set the mapping in the destination to <ignore>.

 

[ReportDr00]

Thanks, thats how i did it.