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...
Saturday, April 14, 2007
Subscribe to:
Post Comments (Atom)
Rick Choi's Pro blog. I talk about Programming, Development.
1 comment:
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.
Post a Comment