BIDS 2008 SSIS Package Failing on Windows 7 64, PervasiveOLEDB.11.0 provider is not registered

I have a BIDS 2008 SSIS Package accessing a Pervasive SQL database using the Pervasive PSQL OLE DB Provider.

The package was failing validation at run time with the following message in the Execution Results tab:

Error: System.InvalidOperationException: The 'PervasiveOLEDB.11.0' provider is not registered on the local machine.

Solution

Although I had verified that the Pervasive OLE DB provider had been successfully registered, BIDS was running my package under the 64 Bit Runtime, thus not finding a suitably registered 64-bit provider.

This was easily solved by going to the Project Properties > Debugging and setting the "Run64BitRuntime" to False.

Thanks to Miguel Salles on this thread for the insight.

VBScript (vb.net) to save file as .xlsx not .xls
Is there a reason why SSIS significantly slows down after a few minutes?
SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
unpivot with different destination columns in SSIS Dataflow
SSIS package shows blank screen in design mode
Add SSIS to existing SQL Server instance
Appending Header Record in Flat file SSIS
Project consistency check failed. has a different ProtectionLevel than the project
How to debug SSIS package in SQL Server Management Studio 2017?
ORA-01422 error thrown when executing a stored procedure from SSIS script task, however it executes successfully when run from SQL Developer
SSIS - The process cannot access the file because it is being used by another process
What are the possibilities to call APIs in SSIS (Microsoft SQL Server Integration Services)?
Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
Specified provider is not supported IBMDA400
SSIS Excel Connection Manager using Expression fail : "Cannot update. Database or object is read only"
Connection failure running SSIS package from web service
no leading zero in hours h:mm:ss time format to convert to seconds in a derived column in SSIS
How do I avoid the SSIS error "Unable to determine if the owner (MyOwner) of job MyJob has server access"
How to parameterize a custom SSIS component
SSIS Execute SQL Task SQL Command Issue
Why is my SSIS toolbox empty in Visual Studio 2019 community?
SSIS job step fail : Not using SSL certificate but getting error
Why won't Windows 11 allow an Administrator to run gacutil.exe?
Where are SSIS Packages Saved?
How to change "DestinationName" property of UNION ALL Transformation in SSIS
Difference between .NET, OLEDB, and Native Providers in SSIS
How do I work around the "The process cannot access the file .ISPAC because it is being used by another process" error?
Sql Server SSIS package Flat File Destination file name pattern (date, time or similar)?
Yesterday's date in SSIS package setting in variable through expression