April 11, 2012 at 3:38 pm
hi, i'm trying to import data from a simple excel file to a sqlserver database.
when i deploy the package, i have always a problem witch that the source file is red and don't have any error in the list errors... help pleaaase
April 11, 2012 at 3:41 pm
I'm guessing 64-bit SQL.. HAve you installed the 64-bit ACES drivers?
CEWII
April 11, 2012 at 3:53 pm
No, i don't know that!! what i have to do exactly?
April 11, 2012 at 3:58 pm
Well You will need to download the Microsoft Access Database Engine from MS, it is version 14.x I believe and install it on the server. Another option is to force SSIS to use the 32-bit version of DTEXEC which I think this http://support.microsoft.com/kb/934653 tells you how to do.
CEWII
April 11, 2012 at 4:02 pm
Ok i'm gonna try this, thank's a lot
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy