Home Forums Data Warehousing Integration Services excel migration issue RE: excel migration issue

  • May 8, 2013 at 6:10 am

    #1613297

    db042188 (5/8/2013)

    thx. How 'bout 64 bit ssis pkgs. Do they run with excel. I think you would know if you are running 64 bit ssis by seeing that the path to the dtexec program isnt the x86 path. BTW I hope linked servers arent germane to this answer. We dont use linked servers.

    not germane, no , they just suffer from the same underlying issue: both 64 bit SSIS and Linked servers both will fail unless the 64 bit ACE drivers are installed; it just getting the drivers installed has a bit of a hiccup in the process if the 32 bit ACE Drivers, or Office 2007 /Office 2010 32 bit are already installed on a server.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!