Where so I find the Excel connection manager in SSIS

Posted on 2011-10-14
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.

Question by:chuang4630
    LVL 21

    Expert Comment

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

    LVL 21

    Accepted Solution

    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.
    LVL 1

    Author Comment

    I will try
    LVL 21

    Expert Comment

    Great, thanks for the points and see you in another SSIS question, by the way I blog helpful SSIS/SSRS stuff at    consider taking a look and following :)

    Jason Yousef

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how the fundamental information of how to create a table.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now