I've had openrowset do some very weird things when connecting to an Oracle database, so I've generally steered away from using it in general. Overall my conclusion is that the ACE 14 driver wasn't really meant to be a working solution for BIDS, but something that you can use with C# or within a script task. Maybe the next version of SQL Server will be able to use the driver properly.