How to load columns with the uniqueidentifier data type?
I'm Migrating SSIS 2008 packages to Bo Sap Data Services.
I'm having trouble finding material on:
How to load columns with the uniqueidentifier data type? How to Generate uniqueidentifier?
Can you give me some tips?
Tutorials about these types of cargo ...
Michael vasanth replied
i understood your problem, if you import any table having uniqueidentifier data type into Repositary, it does not show that column in designer so we can not insert the values into the column
sql server table-----
Imported table in repo
solution is simple, use target option post load command tab as below
update the table by using newid() function