SSIS Error : Resolve transformation errors in 64-bit version of SSIS in debug mode
September 21st, 2010
No comments
In 64 bit operating systems, SSIS transformations ( especially excel) and tasks throws errors that could be annoying. You will often come across errors as shown below.
SSIS package “Package.dtsx” starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC00F9304 at Package, Connection manager “Excel Connection Manager“: 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. Read more…
Categories: DFT, SQL Server, SSIS, SSIS 2008, SSIS Errors 64-bit, Connection Managers, DFT, errors, Excel, Sql server 2008, SSIS, SSIS errors