The requested OLEDB Provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 32-bit driver is not installed, run the pakcage in 64 bit mode.
-
Hi all, I am getting the above error when I run my SSIS Package, but when I researched about the error, it says that I have 64-bit drivers when SSIS is running as 32 bit, but I changed the SSIS Project properties to 64 bit still it gives me the same error. I can't replace the 64 bit drivers with 32 bit drivers. Is there anyway I can run both the drivers or I can run this SSIS package with 64 bit, I am running the Package using Dts.Runtime library of .Net, can I make a setting somewhere to run this package in 64 bit rather than replacing the 64 bit with 32 bit environment? Or If that's not possible I am trying to execute the Package with the following script
declare @r_SSISDB_ExecutionID bigint=0
EXEC SSISDB.catalog.create_execution
@folder_name = N'/Daily Dashboard2/32Bit',
@project_name = null,
@package_name = 'SgLgReporting_SLNewBusinessInProgress_New',
--@reference_id = @v_yourReferenceId,
@use32bitruntime = 1, --To force 32 bit runtime
@execution_id = @r_SSISDB_ExecutionID OUTPUT;
select @r_SSISDB_ExecutionIDBut that the Problem is I don't know what to put at the project_name, because I don't know what's Project name, when I ran select query to get the Project names, the query return no rows Here is the Query:
SELECT * FROM [SSISDB].internal.projects
But if I put null or '' or SSDT project name for the project_name value, it says the Package is not found, I tried by changing to various values like adding .dtsx and removing .dtsx in anyways it says either enter the project_name variable or it says package not found. Any help is going to be a big help man, please help me. And my packages are imported into MSDB database from directly File System location, is it the reason for not having any value for the Project name? Is there any way manually we can add Project name and then execute the Package using that name. I need to run this package my friends, please help me. Thanks in advance.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."