Create Excel file dynamically by SSIS, and calling him by Job Agent, would cause an error of type:
"...Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005...Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered"..."
The reason is that sqlserver is system base 64 bit and Microsoft.Jet.OLEDB is 32 bit base.
The solution consists of two steps:
1. Changed property:Run64BitRuntime to False
2. Instead of using SQL Server Integration Services Package, You have to change it to Operation system(CmdExec), and in the command to write :
"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "C:\...[the package project path]\[the Package name].dtsx".