Steve Hughes is a Principal Consultant at Magenic. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and delivered more than 30 presentations on SQL Server and data architecture over the past six years. He also provides insights from the field on his blog at http://dataonwheels.wordpress.com.
When working with Oracle, drivers are truly a pain to get working correctly. I will discuss my preferred choice and why for the following tools – SSIS, SSAS, and SSRS. SSIS Drivers Without much question, you should use the Attunity tools for working with Oracle data in the Data Flow task. In SSIS 2008, the [...]