Hi, I'm tryingto get a record count out of a databse using OLE DB Source and row count tasks but keep gettingan error. I set up a variable as int32 and select the variable name in the row count task and when I go to theInput Columnstab to select a field to count, it gives me this error: Error at Data Flow Task[Row Count[505]]: The component "Row Count" (505) has forbidden the requested use of the input column with lineage ID 32. I don't even know what this means? thanks,

Don't select any columns. It's a row counter, not a column counter! (It's confusing to see that stuff, I know, but it's a factor of the generic component editor that's being used for that component and why you see the Input Columns tab.)

oh, that is confusing. THANKS!

I've seen this answer before and figured that out on my own. Not trying to be negative or sarcastic (difficult for me), but why does Microsoft allow us to select a column? I've tried playing with this and all I get is errors too (that I spend hours trying to track down via Bing and 'that other search engine'. It would be nice to see an article, complete with code (that works), describing the use of this task object. I'm very frustrated with trying to get this working.