Unable to pull data from an Access 2007 database

Posted on 2011-05-03
Last Modified: 2013-11-10

I have a dataflow task in my SSIS package that pulls the data from an Access 2007 table and loads it in an Excel sheet. I'm getting an error when I do this. Could someone pleease help me ?

Thanks In advance!

Question by:amukta
    LVL 8

    Accepted Solution

    What is the error you have been facing ?

    Below is a link with step by step details of importing data from access in SSIS:

    LVL 30

    Expert Comment

    by:Reza Rad
    I am agree with dba2dba,
    with no error messages and no more information no one can help you much.
    put exact error message here.
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Please check the Error log for error or any warning.

    Author Closing Comment

    Thank you!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    758 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

    13 Experts available now in Live!

    Get 1:1 Help Now