Saturday, April 14, 2007

Row Number Transformation

Here is a Row Number Transformation component of SSIS
http://www.sqlis.com/93.aspx

It's great, just fit my needs.
I suppose SSIS should provide this component...

1 comment:

Rick said...

M$ has a Kb article talking about this
http://support.microsoft.com/kb/908460

Wow, it is so simple...
that's why they don't provide such component?

just don't know if the performance of the script task is good enough.