Posts Tagged With: 2007 Office System Driver

2007 Office System Driver: Data Connectivity Components

This post is more of a note to myself in order to bookmark the Data Connectivity Tools for, in my case, SQL Server installs.

If, for example, you wish to load Excel files with SSIS, your server will require the appropriate drivers, one method to handle this would be to load office onto the server, this is not recommended though for security reasons as it provides an unneeded possible vulnerability, however low and also just means that you have another set of programs to patch as updates are released.

In order to get around this, simply load the free drivers from Microsoft, which are available for download from this address:

http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=7554f536-8c28-4598-9b72-ef94e038c891&displayLang=en

DataConnectivityComponents

Advertisements
Categories: Note To Self, SQL Tools | Tags: , , , | Leave a comment

Blog at WordPress.com.