Has anyone found a solution to this problem? I am running SSIS packages querying tables with literally billions of rows. The pre execution phase takes longer than the queries. I've found in other forums that the pre execution phase scans the whole table. What is the point in that? I have delayed validation and turned ValidataExternalMetadata to False, but still the package takes ages to start processing data.

What can be done?

Many thanks

Ian