If your package does not execute and you find the following errors in validation of package, it is that you are trying to execute a the package on 64-bit machine, which is not supported for some of the SSIS tasks like ExcelSource and Excel Destination
[Excel Destination [23]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[SSIS.Pipeline] Error: Excel Destination failed validation and returned error code 0xC020801C.
[Connection manager "Excel Connection Manager"] Error: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
Resolution:
You can execute the package in 32-bit at the Progress tab suggests. For this go to Project Menu -> Select <Project> properties -> Configuration properties ->Debugging -> Debug Options -> Run64bitRuntime. By default this option is true on a 64-bit machine. Set this to false.
I found this link more helpful
[Excel Destination [23]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[SSIS.Pipeline] Error: Excel Destination failed validation and returned error code 0xC020801C.
[Connection manager "Excel Connection Manager"] Error: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
Resolution:
You can execute the package in 32-bit at the Progress tab suggests. For this go to Project Menu -> Select <Project> properties -> Configuration properties ->Debugging -> Debug Options -> Run64bitRuntime. By default this option is true on a 64-bit machine. Set this to false.
I found this link more helpful
No comments:
Post a Comment