yes, that makes sense. I can visualise how that could work and it strikes me that I could use the SSIS packages for an initial load and then use OPENQUERY to the live oracle db to pick up changes thorughout the day.
I'll experiment with a couple of tables now.
thanks lots!