mister.magoo (7/9/2013)
Ah right, sorry - I hadn't realised that didn't work any more in 2012, and you hadn't mentioned trying that technique...:-)I don't have any other suggestions, sorry.
Sorry about that - I was so wrapped up and frustrated trying numerous alternatives yesterday that I was not at my most lucid.
We have decided, for now, to go down the route of using an ExecuteSQL task to call a proc which truncates/repopulates a physical 'work' table and then using a simple SELECT from that work table in the OLEDB source. A bit messy, but we did not have any better ideas.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.