May 14, 2013 at 1:45 pm
Hi,
When I executed my SSIS package in BIDS successfully but when I try to schedule to execute my SSIS package in SQL Server Agent and I got this error:
Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit. Code: 0XC0209302 Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error Code: 0X00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0X80040154 Description: "Class not registered".
I already installed the data connectivity components from http://www.microsoft.com/en-us/download/details.aspx?id=23734, set run64bitruntime to false, and checked the "Use 32 bit runtime" in SQL Server 2008. I use SSIS 2008.
Please help me, thanks.
May 15, 2013 at 6:37 am
I believe you need to make sure you are use the 32-bit DTEXEC. Check out this article about 2/3 of the way down.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply