Solved

error on a package SSIS

Posted on 2016-07-25
6
43 Views
Last Modified: 2016-08-04
Hello,

How can I resolve the following error in attachment generated by SSIS package?

Thanks

Best Regards
error_ssis.PNG
0
Comment
Question by:bibi92
6 Comments
 
LVL 3

Expert Comment

by:awed1
ID: 41728275
Did you used to have the connection working from that machine and then later came back and it no longer worked?
OR
Is this a machine which has never connected?
0
 
LVL 50

Expert Comment

by:Ryan Chong
ID: 41728690
you may try download and install this driver and see if that resolved the issue?

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-sg/download/details.aspx?id=13255
0
 
LVL 7

Expert Comment

by:Dung Dinh
ID: 41728721
One of things you should change Extend Properties to EXCEL 12.0 for Excel Connection because you are using the Excel version higher than 2003.
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 

Author Comment

by:bibi92
ID: 41742551
The problem is not resolved and the error is the same.
0
 
LVL 3

Accepted Solution

by:
awed1 earned 500 total points
ID: 41742660
Have you read this?

The Excel connection manager doesn't work if SSIS is using the 64bit runtime.

In the Project properties, go to the Debugging Tab and change Run64BitRuntime to False and it should perk up.

There are directions here: http://help.pragmaticworks.com/dtsxchange/scr/FAQ%20-%20How%20to%20run%20SSIS%20Packages%20using%2032bit%20drivers%20on%2064bit%20machine.htm

I found this information here:  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d5946c1c-1c41-493d-a22e-d80144e316df/loop-through-excel-files-and-load-into-sql-server-table?forum=sqlintegrationservices
0
 

Author Closing Comment

by:bibi92
ID: 41742672
thanks regards
1

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft :   M…
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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