in
Eric Vaillancourt on SQL Server...

SSIS Excel file

Last post Thu, Jul 10 2008 12:06 PM by christianxmarin. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • Thu, Jul 10 2008 12:06 PM

    SSIS Excel file

     Hi,

     I'm trying to connect to Excel file and import the file to a server. 

    Where's the error I get:

    Error: 2008-07-10 11:50:52.97
       Code: 0xC020801C

       Source: Copy Data from Final$ to  DP   dbo   MOL_AP_DataFromExcel  Task Excel Source [516]
       Description: An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".
      SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
    End Error

    When I change the Runtime from 64 to 32 in package proprietes, it's working in SQL Server Business Intelligence Development Studio, but not on the server.

    Server : Windows server 2003 64

    DB: SQL Server 2005

    Thanks,

Page 1 of 1 (1 items)
©2008 SQLProf.com & Eric Vaillancourt
Powered by Community Server (Non-Commercial Edition), by Telligent Systems