?
Solved

Where so I find the Excel connection manager in SSIS

Posted on 2011-10-14
4
Medium Priority
?
270 Views
Last Modified: 2013-11-10
I try to create a SSIS package and want to setup the Excel connection. Here are what I did:

1. right click the Data Source
2. Select "new" connection
3. Look for Excel in the provider.

However, i just cannot see any Excel connection in the list. Anyone can show me where it is?

BTW, I use BIDS 2008.

Thanks a lot in advance.

0
Comment
Question by:chuang4630
  • 2
4 Comments
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36972413
In connection area Right click and add new excel connection.


Untitled.png
0
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 2000 total points
ID: 36973257
Also another method, just to add ...

When you add an EXCEL source or destination, it'll allow you to click on MEW and setup a new connection.
SQL1008-FigE.png
0
 
LVL 1

Author Comment

by:chuang4630
ID: 37102609
I will try
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 37543364
Great, thanks for the points and see you in another SSIS question, by the way I blog helpful SSIS/SSRS stuff at http://asqlb.blogspot.com/    consider taking a look and following :)


Regards,
Jason Yousef
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

864 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