I have a package importing a huge sales table (6 bill. rec.) into SQL7 using
a Hit Oledb provider.
I want to append all yesterdays transactions to the table every night.
The dates are stored like 20001005 on the AS400
e.g. something like:
select * from Salesdata where Date >=