I have tables where any IDs (employee or contact or activity etc.) are defined as uniqueidentifier data type in the table which populates the id column as GUID value and as character string not binary. I need to import data using DTS. How do I import ids in these tables? Any help is much appreciated.
Thanks in advance.