Hi,I have windows 2003onour development servers. while establishing the ADO.NET Additional info- "Could not create a DbProviderFactory class for provider invariant name 'MicroSoft.SqlServerCe.Client.3.5'.connection manager in SSIS 2005 & 2008 i m facing the below error."Could not get provider invariant name from the connection type qualifier - "Oracle.DataAccess.Client.OracleConnection,Oracle.DataAccess,Version=2.102.2.20,Culture=neutral"....."While developing the same code in Windows Xp i m not getting any such errors. i m facing the same issue in both SSIS 2005 and SSIS 2008.Any guidance would be very much appreciated.Thanks....Abhishek

Do you get this error when you try to execute your package or during the package design in Visual Studio?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Hi , i have the same Problem Could not create a DbProviderFactory class for the provider invariant name 'Microsoft.SqlServerCe.Client.3.5'. Verify that this provider is installed correctly on this computer. (Microsoft.DataTransformationServices.Design) Could not get provider invariant name from the connection type qualifier "iAnywhere.Data.SQLAnywhere.SAConnection, iAnywhere.Data.SQLAnywhere, Version=10.0.1.38822, Culture= the operating system is a Win2008 r2. I get this error in my VS2008 Bids when i want open the ADO.NET data connection in the connection manager. Can some one halp me with this problem? thanx Wouter

Hi, I have the same issue. Could not get invariant name from the connection type qualifier "System.Data.Odbc.OdbcConnectio, SystemData, Version=2.0.0.0, Culture=neutral, [...]Could not create a DbProviderFactory class for the provider invariant name 'Oracle.DataAccess.Client'. Anyway I doubt I wil get any more help than the others. a+, =) -=Clement=- Configuration : Windows XP 32 Pro BIDS 2005

Did you find a solution to this problem? I saw the same error this morning, which is odd because I'm not using a connection to Oracle. I'm using an ADO.NET connection using the SqlClient provider, but this error is displayed when I attempt to define the SQL in the data source object.

I also have this issue when trying to use ado.net to connect to mysql database. My co-worker doesn't receive the same error. Anyone with a solution?

In my environment, this occurred when the Windows account on the box did not have read access to the Oracle Client installation location. Granting the account that develops or executes the SSIS package, read access to the Oracle Client folder solved the issue.