Hi Dan,

I've done option 2 successfully in the past, also a 3 - create a linked server in MS SQL & query/import the data through that.

I found 3 a bit better (and gave more useful info for debugging), but then I'm happier in SSMS than SSIS.

Cheers

Gaz