Surrogate keys?

#1

Hello,
Does Integration Services (2005) support surrogate keys? Thank you!

#2

Hello ystueker,

Surrogate keys are not a part of SSIS per se but they can be achieved very
easily. Generating them, you could do worse than this

http://www.sqlis.com/default.aspx?93

or this

http://www.sqlis.com/default.aspx?37

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Hello,
Does Integration Services (2005) support surrogate keys? Thank you!

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

Surrogate keys?

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

Surrogate keys? - 02-13-2006 , 10:08 AM

Re: Surrogate keys? - 02-13-2006 , 03:30 PM