in local machine, sql job runs perfectly. inside sql job there ssis package grab excel data , load staging table. there microsoft excel 2010 in system.
now issue on development server. same job same ssis package in network folder run issue. development server consist excel 2013
i don have enough reputation show screenshot of error message. here error saying.
description: ssis error code dts_e_oledberror. ole db error has occurred. error code: 0x80004005. ole db record available. source: "microsoft office access database engine" hresult: 0x80004005 description: "external table not in expected format.". end error error: 2015-07-10 14:16:05.52 code: 0xc020801c source: data flow task excel source [2] description: ssis error code dts_e_cannotacquireconnectionfromconnectionmanager. acquireconnection method call connection manager "excel connection manager" failed error code 0xc0202009. there may error messages posted before more information on why acquireconnection method call failed. error: 2015-07-10 14:16:05.52 code: 0xc0047017 source: data flow task ssis.pipeline description: excel source failed validation , returned error code 0xc020801c. error: 2015-07-10 14:16:05.52 code: 0xc004700c source: data flow task ssis.pipeline description: 1 or more component failed validation
also, 2 things 1) make sure excel file not open 2) ssis cant use excel in 64bit mode, change deployment settings use 32 bit runtime (if youre using sql job, check settings)
Comments
Post a Comment