<div>
Yes.<br />
Install the 64 bit on the server and the 32 bit on the Virtual Server or the Hyper/V
</div>


Yes.
Install the 64 bit on the server and the 32 bit on the Virtual Server or the Hyper/V

<div>
Sorry I do not understand what you mean, I need both set of drivers on the same server... SSIS and SSRS are running on the same server.
</div>


Sorry I do not understand what you mean, I need both set of drivers on the same server... SSIS and SSRS are running on the same server.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Is it possible/OK to install the Microsoft Office 32bit and 64bit drivers on the same server. We have a database server running MSSQL with Business Intelligence. I need SSRS to connect to a 64bit access database but I also need SSIS to connect to a 32 bit MS Excel file.<br />
<br />
What is the best way to do this..?<br />
<br />
Thanks, Greg
</div>
</div>


Hi,

Is it possible/OK to install the Microsoft Office 32bit and 64bit drivers on the same server. We have a database server running MSSQL with Business Intelligence. I need SSRS to connect to a 64bit access database but I also need SSIS to connect to a 32 bit MS Excel file.

What is the best way to do this..?

Thanks, Greg

Microsoft Office Drivers (64bit and 32bit) on the same Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.