Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS & GUIDS

Author  Topic 

www051906
Starting Member

7 Posts

Posted - 2005-10-24 : 16:54:28
When importing a table of data, how to get the uniqueidentifier after the record is created with DTS? Currently, the default value of my uniqueidentifier is NewID().

I've considered removing the default value of my uniqueidentifier field and creating a GUID on the fly during data transformations in DTS. I've actually created a dll that creates this GUID. How can I access this dll's functionality from within the data transformation script?

Or is there another way to create a GUID on the fly during a record transformation in DTS?
   

- Advertisement -