Jeff Moden (6/19/2015)
Heh... I agree. Compared to the ACE driver, the Jet driver was awesome. As for SSIS, we don't even have it loaded because, thankfully, my boss (the Enterprise Architect) hates it as much as I do. 😀 Is it useful? A lot of people find that it is but I've never needed it or DTS to get the job done quickly, easily, and accurately.
And, please... don't even for a second think that I'm badmouthing people that use it. I'm just explaining that I have a personal bit of hate for it and haven't found anything yet that I can't do without it.
I'm sure I saw a letter from Microsoft some years ago saying the ACE driver development was curtailed because it was considered unnecessary with the emphasis on SISS and so forth. I think it was the victim of some internal cuts / restructuring but I might be wrong.
It works ... just ... most of the time ... with a bit of tuning.