Row count task is giving error message in SSIS.

Asked By marvell.kevin 0 points N/A Posted on - 06/27/2011

Hi friends,

I have tried to use Row Count Task in SSIS. I just want to count the incoming rows and to save the count value in a variable. I tried all the possible properties and options in this task.  It was hard for me to configure this task. It was always giving an error in the Editor page itself. Please help me to configure and get the desired results.

Thanks.

• Status: Open
• Question Views: 1923
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by harris.carterr

Go To Solution

Best Answer

Best Answer

Answered By harris.carterr 0 points N/A #130813

Row count task is giving error message in SSIS.

The Row Count Task is one of the easiest tasks in SSIS. To get the value from Row Count Task, you also want to use the Aggregate Task to count the row count value and store it in a variable. Right click on the Row Count Task; you can view the Advanced Editor page. In that 3 tabs will be available. Click on the Input Columns tab and locate the variable option, select the variable that want to be hold the count value and close the Editor page.

Then, drag and drop the Aggregate Task and join it with the Row Count Task. Go to Aggregate Task Editor page, select the variable and in the function drop down list, just select the count option.

Now, the Row Count Task is configured and you can use the variable anywhere in the SSIS which will reflect the Row Count value at run time.

About harris.carterr

Questions
1

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 06/27/2011
• Question Category: MS SQL Server