Hello,
I am developing a few simple SQL-to-flatfile DTS packages.
When I run them from the Enterprise Manager, all are ready within a few
seconds.

When running them from dtsrun.exe, some of them (repeatable) take
minutes, while the other ones stay quick.
I am looking for a clue how to explain this.

During the slow-execution, the whole machine seems to be slow.

The simple select is of the form:
SELECT pit.RecID, pit.RecUID, pit.RecCreated, pit.RecModified,
pit.RecType, pit.HeaderRecUID, pit.ItemType, pit.ItemNumber,
pit.CashierNumber, pit.SellerNumber,
pit.Deleted, pit.SaleValue, pit.ProductNumber, pit.ProductGroup,
pit.Amount, pit.RetailPriceDesired, pit.RetailPriceChanged,
pit.RetailPrice, pit.DiscountValue1,
pit.DiscountPercent1, pit.DiscountType1
FROM dbo.trPosItem1 pit
INNER JOIN dbo.cfPosHeader ph
ON pit.HeaderRecUID = ph.RecUID
WHERE (ph.Branch = 1704)

Thanks in advance, Erik Ykema