How can I create a new GUID for Primary Key in DTS?

#1

I am using DTS to transfer data from 2 tables

However on the destination table the primary key is a uniqueidentifier
which is NOT created automatically. I need to create this in the
transformation somehow.

Is there any way of doing this other than writing a COM object?

Cheers for any help,
DJ.

#2

Function CreateGUID()
Dim TypeLib

TypeLib = CreateObject("Scriptlet.Typelib").GUID
CreateGUID = Mid(TypeLib, 1, Len(TypeLib) - 2)
End Function

"DJ" <superdj (AT) hotmail (DOT) com> wrote

Quote:

I am using DTS to transfer data from 2 tables

However on the destination table the primary key is a uniqueidentifier
which is NOT created automatically. I need to create this in the
transformation somehow.

Is there any way of doing this other than writing a COM object?

Cheers for any help,
DJ.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How can I create a new GUID for Primary Key in DTS?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How can I create a new GUID for Primary Key in DTS? - 10-20-2004 , 05:49 AM

Re: How can I create a new GUID for Primary Key in DTS? - 10-20-2004 , 07:58 AM