Hi, We've just recently upgraded our servers to SQL 2008 versions: Microsoft SQL Server Management Studio 10.0.2531.0 Microsoft Analysis Services Client Tools 10.0.1600.22 Microsoft Data Access Components (MDAC) 3.86.3959 Microsoft MSXML 2.6 3.0 4.0 6.0 Microsoft Internet Explorer 8.0.6001.18702 Microsoft .NET Framework 2.0.50727.3615 Operating System 5.2.3790 VS 2008 versions: Microsoft Visual Studio 2008 Version 9.0.30729.1 SP Microsoft .NET Framework Version 3.5 SP1 Installed Edition: IDE Standard Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB945282) KB945282 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/945282. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946040) KB946040 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946040. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946308) KB946308 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946308. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946344) KB946344 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946344. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946581) KB946581 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946581. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947173) KB947173 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947173. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947540) KB947540 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947540. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947789) KB947789 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947789. SQL Server Analysis Services Microsoft SQL Server Analysis Services Designer Version 10.0.2531.0 SQL Server Integration Services Microsoft SQL Server Integration Services Designer Version 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) SQL Server Reporting Services Microsoft SQL Server Reporting Services Designers Version 10.0.2531.0 Now I am trying to fix the SSIS 2005 pkgs that no longer work. One problem that I've encountered is trying to connect to an Informix db via IBM OLEDB provider. I can preview the tables in BIDS but when I run it, it fails with the following error: Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. It appears this is a rather generic error and does not give much detail. I have searched and read hundreds of cases to find a resolution to this but have found nothing to resolve my issue, in fact the one that closely matched my problem was still unresolved. What I did do that does work is to submit a query via a linked server (created in SQL with the same IBM OLEDB Provider) and not try to establish a connection via the Connection Manager within the pkg. The problem with this is that I will have to create all new packages (which there are several) for gathering data and it is driving me crazy why it works in the SSIS 2005 pkg but does not work since the upgrade. Can anyone steer me in the right direction to resolve this? thanks

Was the upgrade performed on the same box, and is the new environment x64/x86? How about the OLEDB driver? I work with an IBM OLEDB on a daily basis (UniData) and have gotten used to when I see an error message like the above - I check to make sure I'm running with 64 bit disabled. I know Informix has both 32 and 64 bit versions, but thought it might be relevant.

The upgrade was performed on the same box, x86. The OLEDB driver is an IBM Informix OLE DB provider, ifxoledbc. I created a very simple test pkg that uses the informix oledb provider, does a select of one column (which I can preview just fine) and outputs to a recordset. I verified 64 bit was disabled but I still get that pesky DTS_E_OLEDBERROR error. Thanks for any assistance, I will continue searching for any posts that may help me solve this. SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Error: 0xC0202009 at Data Flow Task, OLE DB Source [1]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "Recordset Destination" (34)" wrote 0 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Data Flow Task SSIS package "Package.dtsx" finished: Failure. The program '[6640] Package.dtsx: DTS' has exited with code 0 (0x0).

I would make sure you have also applied all the patches and KBs, SPs etc. One important aspect is to reboot.Arthur My Blog

Error: 0xC0202009 at Data Flow Task, OLE DB Source [1]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009. It's failing at the pre-execute...if the package is running 32 bit, my next guess would be datatype handling. Is there a source file you can pull from that is just nvarchar? Can you see if there are any records being sent through the source output, or is it choking X number of records into it? Since the error is occurring on the OLEDB side, checking the source server and test machine's event logs may be able to provide more insight.