Limiting SQL load in script to improve performance

[#1]

To improve the performance of the load script I wan't to partially load the new data from the SQL database and the old data from QVD files. Is there way to terminate a SQL load based on a certain treshold. In the example below the while statement is not working but gives an idea into what I want to achieve.

LOAD BookInventoryID

    WHERE BookInventoryID < 50000;

SQL SELECT BookInventoryID

WHILE BookInventoryID < 50000       //Statement to terminate SQL load when boundary is reached

FROM DPAR.dbo.BookInventory

ORDER BY BookInventoryID ASC;     //Order records ascending so only first part of the data is evaluated

If you think this is not possible please reply so I can try something different. Thanks!

[nagaiank · Accepted solution]

Try this

SQL SELECT BookInventoryID

FROM DPAR.dbo.BookInventory

WHERE BookInventoryID < 50000

ORDER BY BookInventoryID ASC; 

[#3]

Thanks! This reduces it significantly!