fetching rowcount in ssis

  • How to fetch rowcounts for matched and nomatched outputs of lookup in SSIS?

  • add the row count transformation to the respective data flow, assign the results to seperate variables and use the variable to reference to row count.

  • It is throwing me the error: "Error at upload data borrower table:Component rowocunt has forbidden the requested use of input column with lineage id 17" and it is giving me same error even if I select any other input column

  • you dont need to select any of the columns since you are after a row-count, so un-tick them.. and try again

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply