Solved

SSIS Excel Connection Manager software requirement

Posted on 2015-02-09
6
103 Views
Last Modified: 2016-02-15
Hi, I have an SSIS 2008 Package with Excel connection manager. However, my LIVE machine does not have Microsoft office.
Can anyone please let me know if my package can run without office  ? What softwares are required to run SSIS package with Excel connections ?

Any help is much appreciated.

Thanks
0
Comment
Question by:gvamsimba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 13

Expert Comment

by:LIONKING
ID: 40599269
It should run... The driver that SSIS uses to connect with Excel is installed with SSIS, and you shouldn't need to install anything for your packages to run.
0
 

Author Comment

by:gvamsimba
ID: 40600438
Hi LionKing, what if my LIVE server does not have MS OFFICE 2007 driver installed ? I don't think the SSIS package will run then ?
0
 
LVL 13

Expert Comment

by:LIONKING
ID: 40601405
gvamsimba,

We have SSIS packages running on a server that doesn't have Office installed. Some packages read from Excel files, and they have no problem whatsoever.

Give it a try.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:gvamsimba
ID: 40601438
but you must have that office driver installed ..hence you have no issues....I am 100% sure that you cannot run the package with excel connection without the office driver...it is called access database engine...
0
 
LVL 13

Accepted Solution

by:
LIONKING earned 500 total points
ID: 40601466
The driver is indeed required (sorry, I read your previous post too quick)... But you don't need a full MS Office installation.

This link might help: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/77fd661f-dbf8-4a26-9574-f364d8167c71/ssis-excel-conection-manager-error-does-it-require-ms-excel-installation?forum=sqlintegrationservices
0
 

Author Closing Comment

by:gvamsimba
ID: 40601489
Good
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Shrink hurting performance? 4 49
Linked Server - SP with Param to VIew 7 29
grouping by date only 6 22
I am new to using JSON in SQL Server 2 58
In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question