Retrieving Unique Identifier

#1

I know that I have asked this question but I forgot how to
do it.

I have a DTS package that is going to be entering several
records at a time into a table with a primary key
defined. What I need to do is when I insert a record into
that table, I need to be able to retrieve that id after it
is created and update it to another table. How can I do
this?

Thanks in advance.

#2

Hi ScubaFrog,
You can use lookups for these...
http://www.sqldts.com/default.aspx?6,107,277,7,1
JFB

"ScubaFrog" <scubafrog79 (AT) spammeanddie (DOT) bellsouth.net> wrote

Quote:

I know that I have asked this question but I forgot how to
do it.

I have a DTS package that is going to be entering several
records at a time into a table with a primary key
defined. What I need to do is when I insert a record into
that table, I need to be able to retrieve that id after it
is created and update it to another table. How can I do
this?

Thanks in advance.

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

Retrieving Unique Identifier

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

Retrieving Unique Identifier - 07-09-2003 , 10:28 PM

Re: Retrieving Unique Identifier - 07-10-2003 , 10:43 AM