Hi,

In sequence container i am having 15 Dataflowtask.

In each Dataflowtask i am downloading table.so that i am adding rowcount transformation to get the count of number of rows.

After deploying to ssis catalog 2012 three dataflow task rowcount returns 0 Then when i select the table i am able to see the number of rows.

Please suggest.

Hi Priyanka,

What is different between these three and the rest?

Are you logging the value of those variables with an Execute SQL Task in a table? Are you using the correct parameters when logging those variables?

When you run the package, what does the log shows you? (run with verbose to see row counts per transformation)

Hi Priyanka,

Is it working differently after you deployed to SSIS Catalog or is it behaving same while you execute in Visual Studio?

Prathy :)

Is it working differently after you deployed to SSIS Catalog or is it behaving same while you execute in Visual Studio?

Yes its working properly in visual studio .But in ssis catalog i am seeing this issue.

Are you logging the value of those variables with an Execute SQL Task in a table? Are you using the correct parameters when logging those variables?

yup i am using correct variable

When you run the package, what does the log shows you? (run with verbose to see row counts per transformation)

I will check

Is it working differently after you deployed to SSIS Catalog or is it behaving same while you execute in Visual Studio?

Yes its working properly in visual studio .But in ssis catalog i am seeing this issue.

Are you logging the value of those variables with an Execute SQL Task in a table? Are you using the correct parameters when logging those variables?

yup i am using correct variable

When you run the package, what does the log shows you? (run with verbose to see row counts per transformation)

I will check

Hi,

Currently its working.

I added connector in between data flow tasks which is in sequence container. So now its working.

Also make sure that you are not overwriting variables values before you count number of rows with Execute SQL Task.

Actually in dataflowtask there is Source -->rowcount transformation=>destination.There is no execute sql task

Let me know how to do this approach

I do not see how it worked in development and did not after deployment.

if you do it like Source -->rowcount transformation=>destination you must be all set, there is no need for further action.

I noticed you do not QA enough your development.