sql server dts: Row Count task Error forbidden the requested -- sql server dts

Row Count task Error forbidden the requested

luna.dave NO[at]SPAM gmail.com
5/31/2006 5:53:06 AM

sql server dts:

When I try to use the rowcount component with SSIS I'm getting the
following error message:

Error at Data Flow Task [Row Count [205]]: The component "Row Count"
(205) has forbidden the requested use of the input column with lineage
ID 320

Any help would be appreciated. I have been trying many different ways
but nothing. The way that is connected to the Row Count component is
though a Merge Join task, then from there to the rowCount. Any ideas:

Dave.

Re: Row Count task Error forbidden the requested

Allan Mitchell
6/4/2006 11:16:20 PM

Hello luna.dave@gmail.com,

That error maps to this description

DTS_E_CANTSETUSAGETYPE

It would seem you have checked the column box next to a column/>1 column
in the Input Columns tab om the Row Count transform. Don't

The UI to this component is the advanced UI and this is one of the reasons
we wrote and extended our own version of this component.

Row Count Plus Transformation
(http://www.sqlis.com/default.aspx?77)

Allan

[quoted text, click to view]