Post reply

Some problem in SSIS 2008 when Excel is used

  • July 9, 2010 at 8:13 am

    #237570

    Hi friends,

    Is there any known issue with EXcel source/ destination in SSIS 2008 ?

    I have got the below error when the excel is either source or destination along with OLEDB...

    [Excel Destination [128]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    [Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

    As the second error says it not supported 64 bit version, mine is SQL 2008 64 bit .

    So is there any solution for this ?

    Thanks & Regards,
    MC

  • July 9, 2010 at 8:32 am

    #1190828

    Well, the problem is quite obvious and the error message is quite clear:

    no excel support for 64-bit. So it is not an error, it is by design 🙂

    Luckily, the solution is simple:

    in SSIS 2008 BIDS, set the property Run64RunTime to false.

    In SQL Server Agent you have the option in the SSIS job step to let the jobstep run in 32-bit.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 9, 2010 at 8:58 am

    #1190845

    Hi thanks for the reply.

    I had a look into the by right clicking the SQL Server Business Intelligence Development Studio -->Property --> Compatibility

    There nothing is checked, is this is the one you specified below? I have attached the screenshot.

    Thanks & Regards,
    MC

  • July 9, 2010 at 9:16 am

    #1190864

    Hey I under stood... I have made it to false now. it is working now...

    Thanks lot mate... 🙂

    I have attached the screenshot might help some one else

    Navigate to Project-->Properties-->Run64BitRuntime = False

    Thanks & Regards,
    MC

  • September 13, 2013 at 5:16 pm

    #1650198

    Thanks a ton.I faced this issue today and I sorted out by seeing your screenshot..

  • July 29, 2014 at 6:11 am

    #1733155

    This really helped!!

    And as said, I hope I remember this when this problem crops up again.

    Regards,

    Namrata

  • November 21, 2014 at 1:50 pm

    #1760273

    Thanks for this post. It helped me today as well- a full 4 years after you wrote it.

  • September 30, 2015 at 4:31 pm

    #1830618

    I must be stupid. I'm not seeing it. Closest I get is Forced Execution Value Int32 or Int64.....

  • October 1, 2015 at 1:37 am

    #1830646

    CptCrusty1 (9/30/2015)

    I must be stupid. I'm not seeing it. Closest I get is Forced Execution Value Int32 or Int64.....

    You have to right-click on the SSIS project and go to properties.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 18, 2015 at 4:59 pm

    #1840862

    I dont exactly have SSIS 2005 handy, though in 2008 if it is not too different ...

    Right click the project name in the solution explorer > properties > debugging ?(in 2008 at least) > run64bitRuntime <-- set this attribute to false.

    ----------------------------------------------------

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply