Craig, sorry for late reply, I was out on vacation, Yeah my query has been resolved. thank you

Hi Kraig,

thanks for the reply.

I have attached both the queries, table scripts and execution plans for both queries.

The data retrieved by the query is 182296.

I am not good at evaluating...

Hi Koen verbeeck,

thanks for providing such great link

The SSIS tuning tip that everyone misses.

I went through the whole blog. it was very usefull.

Hi koen verbeeck,

Thanks a lot, now i got understood.

So whether each buffers max size could be 100mb or the 100mb is the max limit for any number of buffers that...

when we run the package and monitor the task manager for CPU and network utilization CPU consumed is less than 10%. though data in the source table is having more...

Thanks Elliott.

Sorry for not providing the sufficient information.

We have a master package which triggers all the packages in sequencial order since we are using checkpoints.

These packages are running in client's...

Hi martin,

I apologize for the late reply,

Thanks a lot

setting a delay validation true worked

Thank you

Hi, thanks a lot for the quick reply.

Yes, file name is stored in a variable and verified that its correct. When we run the package from file system its running...

Thanks Daniel, I would profile the data and change data types and sizes according to the profile.