SSIS - Get identity of data just entered

#1

Hi... I'm using SQL 2K5. I creating an SSIS package that is entering data
into one table that has an identity field, once I enter the data, which would
be one record. I need to get that identity number for the next step in my
package...

How can I do this?

#2

Hello scuba79,

Have a look at this way.

http://wiki.sqlis.com/default.aspx/S...tyColumns.html

Allan

Quote:

Hi... I'm using SQL 2K5. I creating an SSIS package that is entering
data into one table that has an identity field, once I enter the data,
which would be one record. I need to get that identity number for the
next step in my package...

How can I do this?

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

SSIS - Get identity of data just entered

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

SSIS - Get identity of data just entered - 01-04-2006 , 03:46 PM

Re: SSIS - Get identity of data just entered - 01-04-2006 , 04:13 PM