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