Thanks All.

I will work on optimizing the query.

One last quick question(want to know if below thing works)-

Using my SSIS package, first I will be writing the header data to the...

I can even work with a query instead of view.

Again,I just want to confirm if working with a table runs fast than a view?

Yes. I got to know that Rowcount variable will not be updated until the complete control flow completes.

The sql table have millions of records.Is that the reason it is taking...

yes, It's a View.

I need to get the count(for header data) first as I need to write the header data(which includes count) first on the destination file and then the data.

Sorry to say this.

Actually I am new to working on SQL and creating SSIS Packages. So, can you please explain that to me in a simplified way.

If the table from...

• This reply was modified 4 years, 7 months ago by  binds.

Hello,

I am also facing the problem with similar kind of Issue. I hope you can help me on this.

My task is to store the count(which is nothing but the total...