12/1/2008 6:41:39 PM #

This is a superb component! Is there any chance that you might be considering any enhancements? I have a situation where I am loading historical employee records for over 7,000 employees averaging about 9 records each. I am using the Row Number Transformation to generate a sequence number for each historical record but I have to process each employee separately in a Foreach loop to get the sequence number to start over for each employee. It would be nice if I could just get the sequence number to start over when the value of a specified field changes. How hard would this be to implement?

Feel free to email me if you have any questions or if my comments aren't entirely clear.

Thank you!
Bryant

Bryant

12/3/2008 12:07:19 PM #

"Cannot show the editor for this task. The method or operation is not implemented."

I also can not find the editor.....

===================================

Unexpected exception for RowNumberTransformUI.Edit

===================================

Could not load type 'Microsoft.SqlServer.Dts.Design.IDtsPipelineEnvironmentService' from assembly 'Microsoft.SqlServer.Dts.Design, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. (Konesans.Dts.Pipeline.RowNumberTransformUI)

------------------------------
Program Location:

   at Konesans.Dts.Pipeline.RowNumberTransform.RowNumberTransformUIForm..ctor(IDTSComponentMetaData90 dtsComponentMetaData, Variables variables, Connections connections, IServiceProvider serviceProvider)
   at Konesans.Dts.Pipeline.RowNumberTransform.RowNumberTransformUI.Edit(IWin32Window parentWindow, Variables variables, Connections connections)

Nagendra R

12/10/2008 6:19:15 PM #

I'm getting the same error as Nagendra R.  I can however load it if I right click and show the advanced editor.

Jennifer W

1/7/2009 9:46:44 PM #

Note that if the data is coming from a query, and the query is running against SQL Server 2005 or later, you can also get a row number natively.
For example:

select
  name,
  cast(row_number() over(order by name) as int) as row_num
from
  sys.tables
order by
  name

Geoff B

2/11/2009 8:12:46 PM #

Hello Darren,

I think this is a great component but do have some questions:
-- You say that the Seed value is a INT32, I use a variable intDimSK defined as INT32, when I use the expression for the SEED = @[User::intDimSK] I get error message: Cannot convert System.int32 to system.decimal??? The Seed is an INT32 so why should it be converted?

-- When I use (DT_DECIMAL,2)@[User::intDimSK] I get error message: Specified OLE variant is invalid. (Microsoft.DataTransformationServices.Controls)

What am I doing wrong?

Regards,
Arjan Fraaij

Arjan Fraaij

2/11/2009 8:17:37 PM #

Darren,

Sorry found a solution, a bit strange to do but it works.

(DT_DECIMAL,0) (DT_WSTR,10)@[User::intDimSK]

So first convert INT32 Variable to WSTR and then to DT_Decimal.
Or simply define the variable as STRING instead of INT32...

Arjan Fraaij

3/18/2009 9:32:58 PM #

Has anyone found a solution for this problem?
===================================

Unexpected exception for RowNumberTransformUI.Edit

===================================

Could not load type 'Microsoft.SqlServer.Dts.Design.IDtsPipelineEnvironmentService' from assembly 'Microsoft.SqlServer.Dts.Design, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. (Konesans.Dts.Pipeline.RowNumberTransformUI)

------------------------------
Program Location:

   at Konesans.Dts.Pipeline.RowNumberTransform.RowNumberTransformUIForm..ctor(IDTSComponentMetaData90 dtsComponentMetaData, Variables variables, Connections connections, IServiceProvider serviceProvider)
   at Konesans.Dts.Pipeline.RowNumberTransform.RowNumberTransformUI.Edit(IWin32Window parentWindow, Variables variables, Connections connections)

Rick Fitch

6/5/2009 9:14:12 PM #

Now the download for 2005 version is not even working.

bob

6/16/2009 2:36:31 PM #

Hello Darren,

I'm having a similar issue as Arjan but I am unable to use his solution.  I continue to get the "(DT_DECIMAL,0) (DT_WSTR,10)@[User::RowCount] is not a valid value for Decimal." error.  I am entering this value in the Seed property.  Is this the proper location?  Arjan mentions expressions but I don't see them as being available.

Regards,
Mike Latimer

Mike Latimer

7/1/2009 12:02:32 PM #

Mike,
Expressions on components are only visible on the hosting Data Flow task, not at the individual component level. (Properties of Data Flow --> Expresions)
The variable used in the conversion (DT_DECIMAL,0)@[User::intDimSK] must be the type String and must have a default value.

carvilaso